1000
|
It is possible to clip the bar's caption to bar, when the time scale is changed

Dim h
With Exg2antt1
.Columns.Add("Task")
With .Chart
.set_PaneWidth(False,48)
.FirstVisibleDate = #12/27/2000#
With .Bars.Item("Task")
.Pattern = exontrol.EXG2ANTTLib.PatternEnum.exPatternBox
.Height = 13
End With
End With
With .Items
h = .AddItem("Task 1")
.AddBar(h,"Task",#1/2/2001#,#1/6/2001#,"K1","This is a bit of text that get's clipped")
.set_ItemBar(h,"K1",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarHAlignCaption,4)
.set_ItemBar(h,"K1",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarToolTip,.get_ItemBar(h,"K1",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarCaption))
h = .AddItem("Task 2")
.AddBar(h,"Task",#1/2/2001#,#1/6/2001#,"K1","This is a bit of text that is not clipped")
.set_ItemBar(h,"K1",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarHAlignCaption,1)
End With
End With
|
999
|
How can I change the color for all bars with the key matching a pattern

Dim h
With Exg2antt1
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
.Chart.set_PaneWidth(False,64)
.Debug = True
With .Items
h = .AddItem("Task 1")
.AddBar(h,"Task",#1/2/2001#,#1/4/2001#,"A")
.AddBar(h,"Task",#1/5/2001#,#1/7/2001#,"B1")
.AddBar(h,"Task",#1/8/2001#,#1/17/2001#,"B2")
.AddBar(.AddItem("Task 2"),"Task",#1/2/2001#,#1/4/2001#,"K3")
.AddBar(.AddItem("Task 4"),"Task",#1/2/2001#,#1/4/2001#,"B4")
.set_ItemBar(0,"<B*>",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarColor,255)
End With
End With
|
998
|
How can I change the color for all bars in the same item with the key matching a pattern

Dim h
With Exg2antt1
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
.Chart.set_PaneWidth(False,64)
.Debug = True
With .Items
h = .AddItem("Task 1")
.AddBar(h,"Task",#1/2/2001#,#1/4/2001#,"A")
.AddBar(h,"Task",#1/5/2001#,#1/7/2001#,"B1")
.AddBar(h,"Task",#1/8/2001#,#1/17/2001#,"B2")
.AddBar(.AddItem("Task 2"),"Task",#1/2/2001#,#1/4/2001#,"K3")
.AddBar(.AddItem("Task 4"),"Task",#1/2/2001#,#1/4/2001#,"K4")
.set_ItemBar(h,"<B*>",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarColor,255)
End With
End With
|
997
|
How can I change the color for all bars in the same item

Dim h
With Exg2antt1
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
With .Items
h = .AddItem("Task 1")
.AddBar(h,"Task",#1/2/2001#,#1/4/2001#,"K1")
.AddBar(h,"Task",#1/5/2001#,#1/7/2001#,"K2")
.AddBar(.AddItem("Task 2"),"Task",#1/2/2001#,#1/4/2001#,"K3")
.AddBar(.AddItem("Task 4"),"Task",#1/2/2001#,#1/4/2001#,"K4")
.set_ItemBar(h,"<*>",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarColor,255)
End With
End With
|
996
|
How can I write a special number for each date related to a bar

Dim h
With Exg2antt1
.BeginUpdate()
.Columns.Add("Task")
With .Chart
.FirstVisibleDate = #1/1/2001#
.set_PaneWidth(False,32)
.LevelCount = 2
End With
With .Items
h = .AddItem("Task")
.AddBar(h,"Task",#1/2/2001#,#1/13/2001#,"1")
End With
With .Chart.Notes
With .Add("N1",Exg2antt1.Items.FirstVisibleItem,"1","")
.RelativePosition = "S+2"
.set_PartText(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,"4")
.set_PartFixedWidth(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,18)
.set_PartHOffset(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,-9)
.set_PartBackColor(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,Color.FromArgb(255,255,0))
.ShowLink = exontrol.EXG2ANTTLib.NoteLinkTypeEnum.exNoteLinkHidden
.set_PartVisible(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,True)
End With
With .Add("N2",Exg2antt1.Items.FirstVisibleItem,"1","")
.RelativePosition = "S+3"
.set_PartText(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,"4")
.set_PartFixedWidth(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,18)
.set_PartHOffset(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,-9)
.set_PartBackColor(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,Color.FromArgb(255,255,0))
.ShowLink = exontrol.EXG2ANTTLib.NoteLinkTypeEnum.exNoteLinkHidden
.set_PartVisible(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,True)
End With
With .Add("N3",Exg2antt1.Items.FirstVisibleItem,"1","")
.RelativePosition = "S+4"
.set_PartText(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,"5")
.set_PartFixedWidth(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,18)
.set_PartHOffset(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,-9)
.set_PartBackColor(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,Color.FromArgb(0,255,0))
.ShowLink = exontrol.EXG2ANTTLib.NoteLinkTypeEnum.exNoteLinkHidden
.set_PartVisible(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,True)
End With
With .Add("N4",Exg2antt1.Items.FirstVisibleItem,"1","")
.RelativePosition = "S+5"
.set_PartText(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,"5")
.set_PartFixedWidth(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,18)
.set_PartHOffset(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,-9)
.set_PartBackColor(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,Color.FromArgb(0,255,0))
.ShowLink = exontrol.EXG2ANTTLib.NoteLinkTypeEnum.exNoteLinkHidden
.set_PartVisible(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,True)
End With
With .Add("N5",Exg2antt1.Items.FirstVisibleItem,"1","")
.RelativePosition = "S+6"
.set_PartText(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,"8")
.set_PartFixedWidth(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,18)
.set_PartHOffset(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,-9)
.set_PartBackColor(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,Color.FromArgb(255,0,0))
.ShowLink = exontrol.EXG2ANTTLib.NoteLinkTypeEnum.exNoteLinkHidden
.set_PartVisible(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,True)
End With
With .Add("Z",Exg2antt1.Items.FirstVisibleItem,"1","")
.RelativePosition = "E"
.set_PartText(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,"4")
.set_PartFixedWidth(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,18)
.set_PartHOffset(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,-9)
.set_PartBackColor(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,Color.FromArgb(255,128,0))
.set_PartCanMove(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,True)
.ShowLink = exontrol.EXG2ANTTLib.NoteLinkTypeEnum.exNoteLinkHidden
.set_PartVisible(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,True)
End With
End With
.EndUpdate()
End With
|
995
|
How can I assign a note to be always in the center of the bar

Dim h
With Exg2antt1
.BeginUpdate()
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
.Chart.set_PaneWidth(False,96)
With .Items
h = .AddItem("Task 1")
.AddBar(h,"Task",#1/5/2001#,#1/8/2001#,"1")
End With
With .Chart.Notes
With .Add("Note",Exg2antt1.Items.FirstVisibleItem,"1","")
.RelativePosition = 0.5
.set_PartText(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,"note<br>center")
.set_PartBackColor(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,Color.FromArgb(255,255,0))
.set_PartVisible(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd,False)
.ShowLink = exontrol.EXG2ANTTLib.NoteLinkTypeEnum.exNoteLinkHidden
End With
End With
.EndUpdate()
End With
|
994
|
How can I assign a note relative to the start of the bar, and let it be movable

Dim h
With Exg2antt1
.BeginUpdate()
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
.Chart.set_PaneWidth(False,96)
With .Items
h = .AddItem("Task 1")
.AddBar(h,"Task",#1/5/2001#,#1/8/2001#,"1")
End With
With .Chart.Notes
With .Add("Note",Exg2antt1.Items.FirstVisibleItem,"1","")
.RelativePosition = "S+1"
.set_PartText(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,"<%d%>")
.set_PartFixedWidth(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,18)
.set_PartHOffset(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,9)
.set_PartCanMove(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,True)
.set_PartBackColor(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,Color.FromArgb(255,255,0))
.set_PartVisible(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd,False)
.ShowLink = exontrol.EXG2ANTTLib.NoteLinkTypeEnum.exNoteLinkHidden
End With
End With
.EndUpdate()
End With
|
993
|
How can I associate a note relative to the start of the bar

Dim h
With Exg2antt1
.BeginUpdate()
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
.Chart.set_PaneWidth(False,96)
With .Items
h = .AddItem("Task 1")
.AddBar(h,"Task",#1/5/2001#,#1/8/2001#,"1")
End With
With .Chart.Notes
With .Add("Note",Exg2antt1.Items.FirstVisibleItem,"1","")
.RelativePosition = "S+1"
.set_PartText(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,"<%d%>")
.set_PartFixedWidth(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,18)
.set_PartHOffset(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,9)
.set_PartBackColor(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,Color.FromArgb(255,255,0))
.set_PartVisible(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd,False)
.ShowLink = exontrol.EXG2ANTTLib.NoteLinkTypeEnum.exNoteLinkHidden
End With
End With
.EndUpdate()
End With
|
992
|
How can I associate a note relative to the end of the bar, so if the bar is resized at the end, the not is moved accordingly

Dim h
With Exg2antt1
.BeginUpdate()
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
.Chart.set_PaneWidth(False,96)
With .Items
h = .AddItem("Task 1")
.AddBar(h,"Task",#1/5/2001#,#1/8/2001#,"1")
End With
With .Chart.Notes
With .Add("Note",Exg2antt1.Items.FirstVisibleItem,"1","")
.RelativePosition = "E-1"
.set_PartText(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,"<%d%>")
.set_PartFixedWidth(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,18)
.set_PartHOffset(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,9)
.set_PartVisible(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd,False)
.ShowLink = exontrol.EXG2ANTTLib.NoteLinkTypeEnum.exNoteLinkHidden
End With
End With
.EndUpdate()
End With
|
991
|
How can I associate a note relative to the end of the bar, so if the bar is resized at the end, the not is moved accordingly

Dim h
With Exg2antt1
.BeginUpdate()
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
.Chart.set_PaneWidth(False,96)
With .Items
h = .AddItem("Task 1")
.AddBar(h,"Task",#1/5/2001#,#1/8/2001#,"1")
End With
With .Chart.Notes
With .Add("Note",Exg2antt1.Items.FirstVisibleItem,"1","")
.RelativePosition = 1
.set_PartText(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,"End")
.set_PartVisible(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd,False)
.ShowLink = exontrol.EXG2ANTTLib.NoteLinkTypeEnum.exNoteLinkHidden
End With
End With
.EndUpdate()
End With
|
990
|
How can I hide a bar without removing it
With Exg2antt1
.BeginUpdate()
With .Chart
.FirstVisibleDate = #1/1/2001#
.set_PaneWidth(False,128)
.LevelCount = 2
End With
.HeaderVisible = exontrol.EXG2ANTTLib.HeaderVisibleEnum.exHeaderVisibleExtendLevels
.Columns.Add("Column")
With .Items
.AddBar(.AddItem("Item 1"),"Task",#1/2/2001#,#1/4/2001#,"B1")
.AddBar(.AddItem("Item 2"),"Task",#1/6/2001#,#1/14/2001#,"B2")
.AddLink("L1",.get_FindItem("Item 1",0),"B1",.get_FindItem("Item 2",0),"B2")
.set_ItemBar(.FirstVisibleItem,.get_FirstItemBar(.FirstVisibleItem),exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarTransparent,100)
End With
.EndUpdate()
End With
|
989
|
How can I align the caption in the note

Dim h
With Exg2antt1
.BeginUpdate()
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
.Chart.set_PaneWidth(False,96)
With .Items
h = .AddItem("Task 1")
.AddBar(h,"Task",#1/5/2001#,#1/8/2001#,"1")
End With
With .Chart.Notes
With .Add("N1",Exg2antt1.Items.FirstVisibleItem,"1","")
.ShowLink = exontrol.EXG2ANTTLib.NoteLinkTypeEnum.exNoteLinkHidden
.set_PartVisible(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd,False)
.set_PartText(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,"S <b><%dd%></b>")
.set_PartFixedWidth(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,48)
.set_PartAlignment(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,exontrol.EXG2ANTTLib.AlignmentEnum.LeftAlignment)
.set_PartVOffset(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,17)
End With
With .Add("N2",Exg2antt1.Items.FirstVisibleItem,"1","")
.RelativePosition = 1
.ShowLink = exontrol.EXG2ANTTLib.NoteLinkTypeEnum.exNoteLinkHidden
.set_PartVisible(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd,False)
.set_PartText(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,"E <b><%dd%></b>")
.set_PartFixedWidth(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,48)
.set_PartAlignment(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,exontrol.EXG2ANTTLib.AlignmentEnum.RightAlignment)
.set_PartVOffset(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,17)
End With
End With
.EndUpdate()
End With
|
988
|
How I can assign a note and let user move the note relative to the bar

Dim h
With Exg2antt1
.BeginUpdate()
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
.Chart.set_PaneWidth(False,96)
With .Items
h = .AddItem("Task 1")
.AddBar(h,"Task",#1/5/2001#,#1/8/2001#,"1")
End With
With .Chart.Notes
With .Add("Note",Exg2antt1.Items.FirstVisibleItem,"1","End")
.set_PartText(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,"Day<br> <%dd%>")
.set_PartCanMove(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,True)
.set_PartVOffset(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,16)
.set_PartTransparency(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,30)
.set_PartToolTip(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,"Click the note and start moving to a new position.")
End With
End With
.EndUpdate()
End With
|
987
|
How can I assign a picture as a note associated with a bar

Dim h
With Exg2antt1
.BeginUpdate()
.set_HTMLPicture("pic1","c:\exontrol\images\zipdisk.gif")
.set_HTMLPicture("pic2","c:\exontrol\images\auction.gif")
.AntiAliasing = True
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
.Chart.set_PaneWidth(False,96)
With .Items
h = .AddItem("Task 1")
.AddBar(h,"Task",#1/5/2001#,#1/8/2001#,"1")
h = .AddItem("Task 2")
.AddBar(h,"Task",#1/7/2001#,#1/11/2001#,"2")
End With
With .Chart.Notes
With .Add("1",Exg2antt1.Items.get_ItemByIndex(0),"1","<img>pic1</img>")
.set_PartShadow(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd,False)
.set_PartBorderSize(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd,0)
.ClearPartBackColor(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd)
.set_PartHOffset(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd,-64)
.set_PartCanMove(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd,True)
End With
With .Add("2",Exg2antt1.Items.get_ItemByIndex(1),"2","<img>pic2</img>")
.set_PartShadow(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd,False)
.set_PartBorderSize(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd,0)
.ClearPartBackColor(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd)
.RelativePosition = 1
.set_PartCanMove(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd,True)
.LinkColor = Color.FromArgb(255,0,0)
.LinkWidth = 2
.LinkStyle = exontrol.EXG2ANTTLib.LinkStyleEnum.exLinkDot
.ShowLink = exontrol.EXG2ANTTLib.NoteLinkTypeEnum.exNoteLinkVisible
End With
End With
.EndUpdate()
End With
|
986
|
How can I assign a picture as a note associated with a bar

Dim h
With Exg2antt1
.BeginUpdate()
.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
.AntiAliasing = True
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
.Chart.set_PaneWidth(False,96)
With .Items
h = .AddItem("Task 1")
.AddBar(h,"Task",#1/5/2001#,#1/8/2001#,"1")
h = .AddItem("Task 2")
.AddBar(h,"Task",#1/7/2001#,#1/11/2001#,"2")
End With
With .Chart.Notes
With .Add("1",Exg2antt1.Items.get_ItemByIndex(0),"1","<img>1</img>")
.set_PartShadow(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd,False)
.set_PartBorderSize(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd,0)
.ClearPartBackColor(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd)
End With
With .Add("2",Exg2antt1.Items.get_ItemByIndex(1),"2","<img>2</img>...<img>3</img>")
.set_PartShadow(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd,False)
.set_PartBorderSize(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd,0)
.ClearPartBackColor(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd)
.RelativePosition = 1
.set_PartCanMove(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd,True)
.LinkColor = Color.FromArgb(255,0,0)
.LinkWidth = 2
.LinkStyle = exontrol.EXG2ANTTLib.LinkStyleEnum.exLinkDot
End With
End With
.EndUpdate()
End With
|
985
|
How can I put a box assigned to a DATE

Dim h
With Exg2antt1
.BeginUpdate()
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
.Chart.set_PaneWidth(False,96)
With .Items
h = .AddItem("Item 1")
h = .AddItem("Item 2")
End With
With .Chart.Notes
With .Add("D1",Exg2antt1.Items.FirstVisibleItem,Exg2antt1.Chart.FirstVisibleDate,"Date:<br><%dd%>/<%mm%><br><b><%yyyy%></b>")
.set_PartCanMove(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd,True)
.set_PartVOffset(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd,20)
.set_PartHOffset(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd,20)
End With
With .Add("D2",Exg2antt1.Items.get_NextVisibleItem(Exg2antt1.Items.FirstVisibleItem),#1/7/2001#,"Date:<br><%dd%>/<%mm%><br><b><%yyyy%></b>")
.set_PartVisible(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,True)
.set_PartText(exontrol.EXG2ANTTLib.NotePartEnum.exNoteStart,"<b><%d%></b>")
.set_PartCanMove(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd,True)
.set_PartVOffset(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd,20)
.set_PartHOffset(exontrol.EXG2ANTTLib.NotePartEnum.exNoteEnd,20)
End With
End With
.EndUpdate()
End With
|
984
|
How can I add a note or a box associated with a bar

Dim h
With Exg2antt1
.BeginUpdate()
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
.Chart.set_PaneWidth(False,96)
With .Items
h = .AddItem("Task 1")
.AddBar(h,"Task",#1/5/2001#,#1/8/2001#,"1","Center")
.set_ItemBar(h,"1",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarExtraCaption,"left")
.set_ItemBar(h,"1",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarExtraCaptionHAlign,16)
h = .AddItem("Task 2")
.AddBar(h,"Task",#1/7/2001#,#1/11/2001#,"2","Center")
.set_ItemBar(h,"2",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarExtraCaption,"right")
.set_ItemBar(h,"2",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarExtraCaptionHAlign,18)
End With
With .Chart.Notes
.Add("1S",Exg2antt1.Items.FirstVisibleItem,"1","Start")
.Add("1F",Exg2antt1.Items.FirstVisibleItem,"1","End").RelativePosition = 1
End With
.EndUpdate()
End With
|
983
|
Is it possible to define different working hours for every week day

Dim h
With Exg2antt1
.BeginUpdate()
With .Chart
.set_PaneWidth(False,14)
.NonworkingDays = 0
.NonworkingHours = 0
.FirstVisibleDate = #1/1/2001#
.LevelCount = 2
With .get_Level(0)
.Alignment = exontrol.EXG2ANTTLib.AlignmentEnum.CenterAlignment
.Label = "<%dddd%>"
End With
With .get_Level(1)
.Label = "<%hh%>"
.Count = 6
End With
.UnitWidth = 16
End With
.Columns.Add("")
With .Items
h = .AddItem(1)
.set_ItemNonworkingUnits(h,False,"weekday(value) != 1 or (weekday(value) = 1 and not ( hour(value) >= 9 and hour(value) <= 14 ))")
h = .AddItem(2)
.set_ItemNonworkingUnits(h,False,"weekday(value) = 2 and ( hour(value) >= 9 and hour(value) <= 14 )")
h = .AddItem(3)
.set_ItemNonworkingUnits(h,False,"weekday(value) = 3")
End With
.EndUpdate()
End With
|
982
|
How can I automatically update the exBarPercent value using a slider control

Dim i
With Exg2antt1
.BeginUpdate()
.Items.AllowCellValueToItemBar = True
With .Chart
.FirstVisibleDate = #1/1/2002#
.set_PaneWidth(False,128)
.Bars.Add("Task%Progress").Shortcut = "Percent"
End With
With .Columns.Add("Percent")
.set_Def(exontrol.EXG2ANTTLib.DefColumnEnum.exCellValueToItemBarProperty,518)
.set_Def(exontrol.EXG2ANTTLib.DefColumnEnum.exCellValueToItemBarKey,"P")
End With
With .Items
i = .AddItem(0)
.set_CellBold(i,0,True)
.get_CellEditor(i,0).EditType = exontrol.EXG2ANTTLib.EditTypeEnum.SliderType
.AddBar(i,"Percent",#1/2/2002#,#1/6/2002#,"P")
.set_ItemBar(i,"P",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarShowPercentCaption,True)
.set_CellValue(i,0,50)
End With
.EndUpdate()
End With
|
981
|
Is there any automatic way to change a property for all bars in the chart
With Exg2antt1
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
With .Items
.AddBar(.AddItem("Task 1"),"Task",#1/2/2001#,#1/4/2001#,"K1")
.AddBar(.AddItem("Task 2"),"Task",#1/2/2001#,#1/4/2001#,"K2")
.AddBar(.AddItem("Task 3"),"Task",#1/2/2001#,#1/4/2001#,"K3")
.AddBar(.AddItem("Task 4"),"Task",#1/2/2001#,#1/4/2001#,"K4")
.set_ItemBar(0,"<*>",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarColor,255)
End With
End With
|
980
|
How can I assign an icon to a bar and I get notified when I click it

Dim h
With Exg2antt1
.BeginUpdate()
.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
.Chart.set_PaneWidth(False,96)
With .Items
h = .AddItem("Task")
.AddBar(h,"Task",#1/5/2001#,#1/10/2001#,"","Caption")
.set_ItemBar(h,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarExtraCaption,"<a1><img>1:8</img></a><a1><img>2</img></a>")
.set_ItemBar(h,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarExtraCaptionHAlign,16)
.set_ItemBar(h,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarExtraCaptionHOffset,5)
End With
.EndUpdate()
End With
|
979
|
How can I assign an icon to a bar so I do not break its caption

Dim h
With Exg2antt1
.BeginUpdate()
.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
.Chart.set_PaneWidth(False,96)
With .Items
h = .AddItem("Task")
.AddBar(h,"Task",#1/5/2001#,#1/10/2001#,"","Caption")
.set_ItemBar(h,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarExtraCaption,"<img>1</img>")
.set_ItemBar(h,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarExtraCaptionHAlign,16)
.set_ItemBar(h,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarExtraCaptionHOffset,5)
.set_ItemBar(h,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarExtraCaptionVOffset,2)
End With
.EndUpdate()
End With
|
978
|
How can I assign multiple lables to the same bar

Dim h1
With Exg2antt1
.BeginUpdate()
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
.Chart.set_PaneWidth(False,96)
With .Items
h1 = .AddItem("Task 1")
.AddBar(h1,"Task",#1/5/2001#,#1/7/2001#,"","Right")
.set_ItemBar(h1,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarHAlignCaption,18)
.AddBar(h1,"",#1/5/2001#,#1/5/2001#,"T1","Left")
.set_ItemBar(h1,"T1",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarHAlignCaption,16)
.AddBar(h1,"",#1/5/2001#,#1/7/2001#,"T2","Center")
.GroupBars(h1,"",True,h1,"T1",True)
.GroupBars(h1,"",True,h1,"T1",False)
.GroupBars(h1,"",True,h1,"T2",True)
.GroupBars(h1,"",False,h1,"T2",False)
End With
.EndUpdate()
End With
|
977
|
Is there any way to have more Captions on a bar than one

Dim h1
With Exg2antt1
.BeginUpdate()
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
.Chart.set_PaneWidth(False,96)
With .Items
h1 = .AddItem("Task 1")
.AddBar(h1,"Task",#1/5/2001#,#1/7/2001#,"","Right")
.set_ItemBar(h1,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarHAlignCaption,18)
.AddBar(h1,"",#1/5/2001#,#1/5/2001#,"T1","Left")
.set_ItemBar(h1,"T1",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarHAlignCaption,16)
.GroupBars(h1,"",True,h1,"T1",True)
.GroupBars(h1,"",True,h1,"T1",False)
End With
.EndUpdate()
End With
|
976
|
How can I assign multiple lables to the same bar at once

Dim h
With Exg2antt1
.BeginUpdate()
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
.Chart.set_PaneWidth(False,96)
With .Items
h = .AddItem("Task 1")
.AddBar(h,"Task",#1/5/2001#,#1/8/2001#,"","Center")
.set_ItemBar(h,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarExtraCaption,"left")
.set_ItemBar(h,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarExtraCaptionHAlign,16)
h = .AddItem("Task 2")
.AddBar(h,"Task",#1/7/2001#,#1/11/2001#,"","Center")
.set_ItemBar(h,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarExtraCaption,"right")
.set_ItemBar(h,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarExtraCaptionHAlign,18)
End With
.EndUpdate()
End With
|
975
|
How can I limit the duration or length of the bar
Dim h
With Exg2antt1
.BeginUpdate()
.Chart.FirstVisibleDate = #1/1/2001#
.Chart.set_ScrollRange(exontrol.EXG2ANTTLib.ScrollRangeEnum.exStartDate,#1/1/2001#)
.Chart.set_ScrollRange(exontrol.EXG2ANTTLib.ScrollRangeEnum.exEndDate,#1/7/2001#)
.Chart.set_PaneWidth(False,128)
.Columns.Add("Column")
With .Items
h = .AddItem("Item 1")
.AddBar(h,"Task",#1/2/2001#,#1/5/2001#)
.set_ItemBar(h,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarMinDuration,2)
.set_ItemBar(h,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarMaxDuration,5)
.set_ItemBar(h,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarCaption,"Min=2 / Max=5")
.set_ItemBar(h,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarHAlignCaption,18)
End With
.EndUpdate()
End With
|
974
|
I have an EBN file how can I apply different colors to it, so no need to create a new one

Dim h,hC
With Exg2antt1
.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
.SelBackColor = .BackColor
.SelForeColor = .ForeColor
.HasLines = exontrol.EXG2ANTTLib.HierarchyLineEnum.exNoLine
.Columns.Add("Default")
With .Items
h = .AddItem("Root")
hC = .InsertItem(h,Nothing,"Default")
.set_ItemBackColor32(hC,&H1000000)
.set_ItemHeight(.InsertItem(h,Nothing,""),6)
hC = .InsertItem(h,Nothing,"Light Green")
.set_ItemBackColor32(hC,&H100ff00)
Exg2antt1.Chart.set_ItemBackColor32(hC,&H100ff00)
.set_ItemHeight(.InsertItem(h,Nothing,""),6)
hC = .InsertItem(h,Nothing,"Dark Green")
.set_ItemBackColor32(hC,&H1007f00)
.set_ItemHeight(.InsertItem(h,Nothing,""),6)
hC = .InsertItem(h,Nothing,"Magenta")
.set_ItemBackColor32(hC,&H1ff7fff)
.set_ItemHeight(.InsertItem(h,Nothing,""),6)
hC = .InsertItem(h,Nothing,"Yellow")
.set_ItemBackColor32(hC,&H17fffff)
.set_ItemHeight(.InsertItem(h,Nothing,""),6)
.set_ExpandItem(h,True)
End With
End With
|
973
|
I need to specify the non-working hours for about 100 days for each item, but the scrolling is very slow. Is there any option to increase the speed

With Exg2antt1
.BeginUpdate()
.AllowChartScrollPage = True
.Columns.Add("Non-Work")
With .Chart
.FirstVisibleDate = #4/4/2009 4:00:00 PM#
.set_PaneWidth(False,52)
.LevelCount = 2
.UnitWidth = 16
With .get_Level(0)
.Label = "<r><%d%>-<%mmm%>"
.Unit = exontrol.EXG2ANTTLib.UnitEnum.exDay
End With
With .get_Level(1)
.Label = "<%hh%>"
.Unit = exontrol.EXG2ANTTLib.UnitEnum.exHour
.Count = 2
End With
End With
With .Items
.AddItem("Default")
.set_ItemNonworkingUnits(.AddItem("Test"),False,"date(shortdate(value)) case(default:0;#4/5/2009# : hour(value) >= 6 and hour(value) <= 12; #4/6/2009# : hour(value) >= 6 and ho" & _
"ur(value) <= 12; #4/7/2009# : hour(value) >= 6 and hour(value) <= 12; #4/8/2009# : hour(value) >= 6 and hour(value) <= 12; #4/9/" & _
"2009# : hour(value) >= 6 and hour(value) <= 12; #4/10/2009# : hour(value) >= 6 and hour(value) <= 12; #4/11/2009# : hour(value) " & _
">= 6 and hour(value) <= 12; #4/12/2009# : hour(value) >= 6 and hour(value) <= 12; #4/13/2009# : hour(value) >= 6 and hour(value)" & _
" <= 12; #4/14/2009# : hour(value) >= 6 and hour(value) <= 12; #4/15/2009# : hour(value) >= 6 and hour(value) <= 12; #4/16/2009# " & _
": hour(value) >= 6 and hour(value) <= 12; #4/17/2009# : hour(value) >= 6 and hour(value) <= 12; #4/18/2009# : hour(value) >= 6 a" & _
"nd hour(value) <= 12; #4/19/2009# : hour(value) >= 6 and hour(value) <= 12; #4/20/2009# : hour(value) >= 6 and hour(value) <= 12" & _
"; #4/21/2009# : hour(value) >= 6 and hour(value) <= 12; #4/22/2009# : hour(value) >= 6 and hour(value) <= 12; #4/23/2009# : hour" & _
"(value) >= 6 and hour(value) <= 12; #4/24/2009# : hour(value) >= 6 and hour(value) <= 12; #4/25/2009# : hour(value) >= 6 and hou" & _
"r(value) <= 12; #4/26/2009# : hour(value) >= 6 and hour(value) <= 12; #4/27/2009# : hour(value) >= 6 and hour(value) <= 12; #4/2" & _
"8/2009# : hour(value) >= 6 and hour(value) <= 12; #4/29/2009# : hour(value) >= 6 and hour(value) <= 12; #4/30/2009# : hour(value" & _
") >= 6 and hour(value) <= 12; #5/1/2009# : hour(value) >= 6 and hour(value) <= 12; #5/2/2009# : hour(value) >= 6 and hour(value)" & _
" <= 12; #5/3/2009# : hour(value) >= 6 and hour(value) <= 12; #5/4/2009# : hour(value) >= 6 and hour(value) <= 12; #5/5/2009# : h" & _
"our(value) >= 6 and hour(value) <= 12; #5/6/2009# : hour(value) >= 6 and hour(value) <= 12; #5/7/2009# : hour(value) >= 6 and ho" & _
"ur(value) <= 12; #5/8/2009# : hour(value) >= 6 and hour(value) <= 12; #5/9/2009# : hour(value) >= 6 and hour(value) <= 12; #5/10" & _
"/2009# : hour(value) >= 6 and hour(value) <= 12; #5/11/2009# : hour(value) >= 6 and hour(value) <= 12; #5/13/2009# : hour(value)" & _
" >= 6 and hour(value) <= 12; #5/14/2009# : hour(value) >= 6 and hour(value) <= 12; #5/15/2009# : hour(value) >= 6 and hour(value" & _
") <= 12; #5/16/2009# : hour(value) >= 6 and hour(value) <= 12; #5/17/2009# : hour(value) >= 6 and hour(value) <= 12; #5/18/2009#" & _
" : hour(value) >= 6 and hour(value) <= 12; #5/19/2009# : hour(value) >= 6 and hour(value) <= 12; #5/20/2009# : hour(value) >= 6 " & _
"and hour(value) <= 12; #5/21/2009# : hour(value) >= 6 and hour(value) <= 12; #5/22/2009# : hour(value) >= 6 and hour(value) <= 1" & _
"2; #5/23/2009# : hour(value) >= 6 and hour(value) <= 12; #5/24/2009# : hour(value) >= 6 and hour(value) <= 12; #5/25/2009# : hou" & _
"r(value) >= 6 and hour(value) <= 12; #5/26/2009# : hour(value) >= 6 and hour(value) <= 12; #5/27/2009# : hour(value) >= 6 and ho" & _
"ur(value) <= 12; #5/28/2009# : hour(value) >= 6 and hour(value) <= 12; #5/29/2009# : hour(value) >= 6 and hour(value) <= 12; #5/" & _
"30/2009# : hour(value) >= 6 and hour(value) <= 12; #5/31/2009# : hour(value) >= 6 and hour(value) <= 12; #6/1/2009# : hour(value" & _
") >= 6 and hour(value) <= 12; #6/2/2009# : hour(value) >= 6 and hour(value) <= 12; #6/3/2009# : hour(value) >= 6 and hour(value)" & _
" <= 12; #6/4/2009# : hour(value) >= 6 and hour(value) <= 12; #6/5/2009# : hour(value) >= 6 and hour(value) <= 12; #6/6/2009# : h" & _
"our(value) >= 6 and hour(value) <= 12; #6/7/2009# : hour(value) >= 6 and hour(value) <= 12; #6/8/2009# : hour(value) >= 6 and ho" & _
"ur(value) <= 12; #6/9/2009# : hour(value) >= 6 and hour(value) <= 12; #6/10/2009# : hour(value) >= 6 and hour(value) <= 12; #6/1" & _
"1/2009# : hour(value) >= 6 and hour(value) <= 12; #6/12/2009# : hour(value) >= 6 and hour(value) <= 12; #6/13/2009# : hour(value" & _
") >= 6 and hour(value) <= 12; #6/14/2009# : hour(value) >= 6 and hour(value) <= 12; #6/15/2009# : hour(value) >= 6 and hour(valu" & _
"e) <= 12; #6/16/2009# : hour(value) >= 6 and hour(value) <= 12; #6/17/2009# : hour(value) >= 6 and hour(value) <= 12; #6/18/2009" & _
"# : hour(value) >= 6 and hour(value) <= 12; #6/19/2009# : hour(value) >= 6 and hour(value) <= 12; #6/21/2009# : hour(value) >= 6" & _
" and hour(value) <= 12; #6/22/2009# : hour(value) >= 6 and hour(value) <= 12; #6/23/2009# : hour(value) >= 6 and hour(value) <= " & _
"12; #6/24/2009# : hour(value) >= 6 and hour(value) <= 12; #6/25/2009# : hour(value) >= 6 and hour(value) <= 12; #6/26/2009# : ho" & _
"ur(value) >= 6 and hour(value) <= 12; #6/27/2009# : hour(value) >= 6 and hour(value) <= 12; #6/28/2009# : hour(value) >= 6 and h" & _
"our(value) <= 12; #6/29/2009# : hour(value) >= 6 and hour(value) <= 12; #6/30/2009# : hour(value) >= 6 and hour(value) <= 12; #7" & _
"/1/2009# : hour(value) >= 6 and hour(value) <= 12; #7/2/2009# : hour(value) >= 6 and hour(value) <= 12; #7/3/2009# : hour(value)" & _
" >= 6 and hour(value) <= 12; #7/4/2009# : hour(value) >= 6 and hour(value) <= 12; #7/5/2009# : hour(value) >= 6 and hour(value) " & _
"<= 12; #7/6/2009# : hour(value) >= 6 and hour(value) <= 12; #7/7/2009# : hour(value) >= 6 and hour(value) <= 12; #7/8/2009# : ho" & _
"ur(value) >= 6 and hour(value) <= 12; #7/9/2009# : hour(value) >= 6 and hour(value) <= 12; #7/10/2009# : hour(value) >= 6 and ho" & _
"ur(value) <= 12; #7/11/2009# : hour(value) >= 6 and hour(value) <= 12; #7/12/2009# : hour(value) >= 6 and hour(value) <= 12; #7/" & _
"13/2009# : hour(value) >= 6 and hour(value) <= 12; #7/14/2009# : hour(value) >= 6 and hour(value) <= 12)")
.set_ItemNonworkingUnits(.AddItem("Test"),False,"date(shortdate(value)) case(default:0;#4/5/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #4/6" & _
"/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #4/7/2009# : hour(value) >= 6 and hour(value) <" & _
"= 10 or hour(value) in (16,17,20,21); #4/8/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #4/9/" & _
"2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #4/10/2009# : hour(value) >= 6 and hour(value) <" & _
"= 10 or hour(value) in (16,17,20,21); #4/11/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #4/1" & _
"2/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #4/13/2009# : hour(value) >= 6 and hour(value)" & _
" <= 10 or hour(value) in (16,17,20,21); #4/14/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #4" & _
"/15/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #4/16/2009# : hour(value) >= 6 and hour(valu" & _
"e) <= 10 or hour(value) in (16,17,20,21); #4/17/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); " & _
"#4/18/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #4/19/2009# : hour(value) >= 6 and hour(va" & _
"lue) <= 10 or hour(value) in (16,17,20,21); #4/20/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21)" & _
"; #4/21/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #4/22/2009# : hour(value) >= 6 and hour(" & _
"value) <= 10 or hour(value) in (16,17,20,21); #4/23/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,2" & _
"1); #4/24/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #4/25/2009# : hour(value) >= 6 and hou" & _
"r(value) <= 10 or hour(value) in (16,17,20,21); #4/26/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20" & _
",21); #4/27/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #4/28/2009# : hour(value) >= 6 and h" & _
"our(value) <= 10 or hour(value) in (16,17,20,21); #4/29/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17," & _
"20,21); #4/30/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #5/1/2009# : hour(value) >= 6 and " & _
"hour(value) <= 10 or hour(value) in (16,17,20,21); #5/2/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17," & _
"20,21); #5/3/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #5/4/2009# : hour(value) >= 6 and h" & _
"our(value) <= 10 or hour(value) in (16,17,20,21); #5/5/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,2" & _
"0,21); #5/6/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #5/7/2009# : hour(value) >= 6 and ho" & _
"ur(value) <= 10 or hour(value) in (16,17,20,21); #5/8/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20" & _
",21); #5/9/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #5/10/2009# : hour(value) >= 6 and ho" & _
"ur(value) <= 10 or hour(value) in (16,17,20,21); #5/11/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,2" & _
"0,21); #5/13/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #5/14/2009# : hour(value) >= 6 and " & _
"hour(value) <= 10 or hour(value) in (16,17,20,21); #5/15/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17" & _
",20,21); #5/16/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #5/17/2009# : hour(value) >= 6 an" & _
"d hour(value) <= 10 or hour(value) in (16,17,20,21); #5/18/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16," & _
"17,20,21); #5/19/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #5/20/2009# : hour(value) >= 6 " & _
"and hour(value) <= 10 or hour(value) in (16,17,20,21); #5/21/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (1" & _
"6,17,20,21); #5/22/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #5/23/2009# : hour(value) >= " & _
"6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #5/24/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in " & _
"(16,17,20,21); #5/25/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #5/26/2009# : hour(value) >" & _
"= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #5/27/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) i" & _
"n (16,17,20,21); #5/28/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #5/29/2009# : hour(value)" & _
" >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #5/30/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value)" & _
" in (16,17,20,21); #5/31/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #6/1/2009# : hour(value" & _
") >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #6/2/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value)" & _
" in (16,17,20,21); #6/3/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #6/4/2009# : hour(value)" & _
" >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #6/5/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) " & _
"in (16,17,20,21); #6/6/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #6/7/2009# : hour(value) " & _
">= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #6/8/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) i" & _
"n (16,17,20,21); #6/9/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #6/10/2009# : hour(value) " & _
">= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #6/11/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) " & _
"in (16,17,20,21); #6/12/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #6/13/2009# : hour(value" & _
") >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #6/14/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value" & _
") in (16,17,20,21); #6/15/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #6/16/2009# : hour(val" & _
"ue) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #6/17/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(val" & _
"ue) in (16,17,20,21); #6/18/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #6/19/2009# : hour(v" & _
"alue) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #6/21/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(v" & _
"alue) in (16,17,20,21); #6/22/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #6/23/2009# : hour" & _
"(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #6/24/2009# : hour(value) >= 6 and hour(value) <= 10 or hour" & _
"(value) in (16,17,20,21); #6/25/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #6/26/2009# : ho" & _
"ur(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #6/27/2009# : hour(value) >= 6 and hour(value) <= 10 or ho" & _
"ur(value) in (16,17,20,21); #6/28/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #6/29/2009# : " & _
"hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #6/30/2009# : hour(value) >= 6 and hour(value) <= 10 or " & _
"hour(value) in (16,17,20,21); #7/1/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #7/2/2009# : " & _
"hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #7/3/2009# : hour(value) >= 6 and hour(value) <= 10 or h" & _
"our(value) in (16,17,20,21); #7/4/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #7/5/2009# : h" & _
"our(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #7/6/2009# : hour(value) >= 6 and hour(value) <= 10 or ho" & _
"ur(value) in (16,17,20,21); #7/7/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #7/8/2009# : ho" & _
"ur(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #7/9/2009# : hour(value) >= 6 and hour(value) <= 10 or hou" & _
"r(value) in (16,17,20,21); #7/10/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #7/11/2009# : h" & _
"our(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #7/12/2009# : hour(value) >= 6 and hour(value) <= 10 or h" & _
"our(value) in (16,17,20,21); #7/13/2009# : hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21); #7/14/2009# :" & _
" hour(value) >= 6 and hour(value) <= 10 or hour(value) in (16,17,20,21))")
.AddItem("Default")
End With
.EndUpdate()
End With
|
972
|
How can I use the CASE statement (CASE usage)
With Exg2antt1
.BeginUpdate()
With .Columns.Add("Value")
.Width = 24
.Editor.EditType = exontrol.EXG2ANTTLib.EditTypeEnum.SpinType
End With
With .Columns.Add("CASE - statment")
.ComputedField = "%0 case (default:'not found';1:%0;2:2*%0;3:3*%0;4:4*%0;5:5*%0;7:'Seven';8:'Eight';9:'Nine';11:'Eleven';13:'Thirtheen';14:'Fourt" & _
"heen')"
.ToolTip = .ComputedField
End With
With .Items
.AddItem(0)
.AddItem(1)
.AddItem(2)
End With
.EndUpdate()
End With
|
971
|
How can I use the CASE statement (CASE usage)
With Exg2antt1
.BeginUpdate()
With .Columns.Add("Value")
.Width = 24
.Editor.EditType = exontrol.EXG2ANTTLib.EditTypeEnum.SpinType
End With
With .Columns.Add("CASE - statment")
.ComputedField = "%0 case (default:'not found';1:'One';2:'Two';3:'Three';4:'Four';5:'Five';7:'Seven';8:'Eight';9:'Nine';11:'Eleven';13:'Thirtheen" & _
"';14:'Fourtheen')"
.ToolTip = .ComputedField
End With
With .Items
.AddItem(0)
.AddItem(1)
.AddItem(2)
End With
.EndUpdate()
End With
|
970
|
I have seen the IN function but it returns -1 or 0. How can I display the value being found ( SWITCH usage )
With Exg2antt1
.BeginUpdate()
With .Columns.Add("Value")
.Width = 24
.Editor.EditType = exontrol.EXG2ANTTLib.EditTypeEnum.SpinType
End With
With .Columns.Add("SWITCH - statment")
.ComputedField = "%0 switch ('not found', 1,2,3,4,5,7,8,9,11,13,14)"
.ToolTip = .ComputedField
End With
With .Items
.AddItem(0)
.AddItem(1)
.AddItem(2)
End With
.EndUpdate()
End With
|
969
|
I have a large collection of constant values and using or operator is a time consuming (IN usage). Is there any way to increase the speed to check if a value maches the collection
With Exg2antt1
.BeginUpdate()
With .Columns.Add("Value")
.Width = 24
.Editor.EditType = exontrol.EXG2ANTTLib.EditTypeEnum.SpinType
End With
With .Columns.Add("IN - statment")
.ComputedField = "%0 in (1,2,3,4,5,7,8,9,11,13,14) ? 'found' : ''"
.ToolTip = .ComputedField
End With
With .Items
.AddItem(0)
.AddItem(1)
.AddItem(2)
End With
.EndUpdate()
End With
|
968
|
How can I automatically update the exBarPercent value using a slider control

Dim i
With Exg2antt1
.BeginUpdate()
.Items.AllowCellValueToItemBar = True
With .Chart
.FirstVisibleDate = #1/1/2002#
.set_PaneWidth(False,128)
.Bars.Add("Task%Progress").Shortcut = "Percent"
End With
With .Columns.Add("Percent")
.set_Def(exontrol.EXG2ANTTLib.DefColumnEnum.exCellValueToItemBarProperty,12)
.set_Def(exontrol.EXG2ANTTLib.DefColumnEnum.exCellValueToItemBarKey,"P")
End With
With .Items
i = .AddItem(0)
.set_CellBold(i,0,True)
With .get_CellEditor(i,0)
.EditType = exontrol.EXG2ANTTLib.EditTypeEnum.SliderType
.set_Option(exontrol.EXG2ANTTLib.EditorOptionEnum.exSliderStep,0.01)
.set_Option(exontrol.EXG2ANTTLib.EditorOptionEnum.exSpinStep,0.01)
.set_Option(exontrol.EXG2ANTTLib.EditorOptionEnum.exSliderMax,1)
.set_Option(exontrol.EXG2ANTTLib.EditorOptionEnum.exSliderWidth,-100)
End With
.set_CellValueFormat(i,0,exontrol.EXG2ANTTLib.ValueFormatEnum.exHTML)
.AddBar(i,"Percent",#1/2/2002#,#1/6/2002#,"P")
.set_ItemBar(i,"P",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarShowPercentCaption,True)
.set_CellValue(i,0,0.5)
End With
.EndUpdate()
End With
|
967
|
How can I automatically update the exBarPercent value using a spin control

Dim i
With Exg2antt1
.BeginUpdate()
.Items.AllowCellValueToItemBar = True
With .Chart
.FirstVisibleDate = #1/1/2002#
.set_PaneWidth(False,128)
.Bars.Add("Task%Progress").Shortcut = "Percent"
End With
With .Columns.Add("Percent")
.set_Def(exontrol.EXG2ANTTLib.DefColumnEnum.exCellValueToItemBarProperty,12)
.FormatColumn = "((0:=round(dbl(%0)*100)) >= 50 ? '<font 8>'+ =:0 + '%</font>' : '<fgcolor=808080><font 6>'+ =:0 + '%</font></fgcolor>')"
End With
With .Items
i = .AddItem(0)
.set_CellBold(i,0,True)
With .get_CellEditor(i,0)
.EditType = exontrol.EXG2ANTTLib.EditTypeEnum.SpinType
.set_Option(exontrol.EXG2ANTTLib.EditorOptionEnum.exSpinStep,0.01)
.set_Option(exontrol.EXG2ANTTLib.EditorOptionEnum.exSliderMax,1)
End With
.set_CellValueFormat(i,0,exontrol.EXG2ANTTLib.ValueFormatEnum.exHTML)
.AddBar(i,"Percent",#1/2/2002#,#1/6/2002#)
.set_CellValue(i,0,0.5)
End With
.EndUpdate()
End With
|
966
|
How do I specify for an item all units as being non-working units

With Exg2antt1
.BeginUpdate()
.AllowChartScrollPage = True
.Columns.Add("Non-Work")
With .Chart
.AllowCreateBar = exontrol.EXG2ANTTLib.CreateBarEnum.exCreateBarAuto
.FirstVisibleDate = #4/3/2009 10:00:00 AM#
.set_PaneWidth(False,64)
.LevelCount = 2
.UnitWidth = 16
With .get_Level(0)
.Label = "<r><%d%>-<%mmm%>"
.Unit = exontrol.EXG2ANTTLib.UnitEnum.exDay
End With
With .get_Level(1)
.Label = "<%hh%>"
.Unit = exontrol.EXG2ANTTLib.UnitEnum.exHour
.Count = 2
End With
End With
With .Items
.AddItem("Default")
.set_ItemNonworkingUnits(.AddItem("All-Non-Working"),False,"1")
.AddItem("Default")
End With
.EndUpdate()
End With
|
965
|
How do I specify for an item all units as being working units

With Exg2antt1
.BeginUpdate()
.AllowChartScrollPage = True
.Columns.Add("Non-Work")
With .Chart
.AllowCreateBar = exontrol.EXG2ANTTLib.CreateBarEnum.exCreateBarAuto
.FirstVisibleDate = #4/3/2009 10:00:00 AM#
.set_PaneWidth(False,64)
.LevelCount = 2
.UnitWidth = 16
With .get_Level(0)
.Label = "<r><%d%>-<%mmm%>"
.Unit = exontrol.EXG2ANTTLib.UnitEnum.exDay
End With
With .get_Level(1)
.Label = "<%hh%>"
.Unit = exontrol.EXG2ANTTLib.UnitEnum.exHour
.Count = 2
End With
End With
With .Items
.AddItem("Default")
.set_ItemNonworkingUnits(.AddItem("All-Working"),False,"0")
.AddItem("Default")
End With
.EndUpdate()
End With
|
964
|
How can I programmatically specify different non-working units ( days, hours ) for different items

Dim h
With Exg2antt1
.BeginUpdate()
.AllowChartScrollPage = True
.Columns.Add("Non-Work")
With .Chart
.AllowCreateBar = exontrol.EXG2ANTTLib.CreateBarEnum.exCreateBarAuto
.Bars.Add("Task:Split").Shortcut = "Task"
.FirstVisibleDate = #7/13/2009 0:00:00 PM#
.set_PaneWidth(False,52)
.LevelCount = 2
.UnitWidth = 16
With .get_Level(0)
.Label = "<r><b><%d%></b> <%mmm%> <%yyyy%>"
.Unit = exontrol.EXG2ANTTLib.UnitEnum.exDay
End With
With .get_Level(1)
.Label = "<%hh%>"
.Unit = exontrol.EXG2ANTTLib.UnitEnum.exHour
.Count = 2
End With
End With
With .Items
h = .AddItem("Item 1")
.set_ItemNonworkingUnits(h,False,"(shortdate(value) = #7/14/2009# and hour(value) >= 6 and hour(value) <= 12)")
.AddBar(h,"Task",#7/14/2009 4:00:00 AM#,#7/14/2009 2:00:00 PM#)
h = .AddItem("Item 2")
.set_ItemNonworkingUnits(h,False,"(((hour(value) >= 4 and hour(value) <= 16) or hour(value) = 2) and month(value) = 7) or ((hour(value) >= 2 and hour(value) < 10" & _
")) and month(value) = 6 or weekday(value) = 6")
.AddBar(h,"Task",#7/14/2009 1:00:00 AM#,#7/14/2009 6:00:00 AM#)
End With
.EndUpdate()
End With
|
963
|
I am programmatically select a date using the Chart.SelectDate property, but can't see why the date is not highlighted. What am I doing wrong
With Exg2antt1
With .Chart
.LevelCount = 2
.FirstVisibleDate = #1/1/2001#
.SelectLevel = 1
.set_SelectDate(#1/4/2001#,True)
End With
End With
|
962
|
How do I show a shorter line in the chart's level

With Exg2antt1
.BeginUpdate()
.GridLineColor = Color.FromArgb(128,128,128)
With .Chart
.DrawLevelSeparator = exontrol.EXG2ANTTLib.LevelLineEnum.exLevelNoLine
.UnitWidth = 24
.FirstVisibleDate = #1/1/2001#
.set_PaneWidth(False,0)
.LevelCount = 2
With .get_Level(0)
.Alignment = exontrol.EXG2ANTTLib.AlignmentEnum.CenterAlignment
.Label = "<%dddd%>"
.DrawTickLines = exontrol.EXG2ANTTLib.LevelLineEnum.exLevelLowerHalf Or exontrol.EXG2ANTTLib.LevelLineEnum.exLevelSolidLine
End With
With .get_Level(1)
.Label = 65536
.Count = 6
.DrawTickLines = &H200 Or exontrol.EXG2ANTTLib.LevelLineEnum.exLevelMiddleLine Or exontrol.EXG2ANTTLib.LevelLineEnum.exLevelSolidLine
.DrawTickLinesFrom(0,exontrol.EXG2ANTTLib.LevelLineEnum.exLevelUpperHalf Or exontrol.EXG2ANTTLib.LevelLineEnum.exLevelSolidLine)
End With
End With
.EndUpdate()
End With
|
961
|
How do I replicate the screen shot http://www.exontrol.com/images/exg2antt9.jpg

Dim h
With Exg2antt1
.BeginUpdate()
With .VisualAppearance
.Add(1,"C:\Program Files\Exontrol\ExG2antt.NET\Sample\EBN\headdark.ebn")
.Add(2,"C:\Program Files\Exontrol\ExG2antt.NET\Sample\EBN\xpbsel.ebn")
.Add(3,"C:\Program Files\Exontrol\ExG2antt.NET\Sample\EBN\headligh.ebn")
.Add(4,"CP:1 0 0 1 1")
End With
.BackColorHeader32 = &H4000000
.Chart.BackColorLevelHeader32 = &H4000000
.SelBackColor32 = &H20000ff
.GridLineColor = Color.FromArgb(128,128,128)
.HeaderHeight = 22
.SelForeColor = Color.FromArgb(0,0,0)
.MarkSearchColumn = False
.ScrollBySingleLine = False
.ShowFocusRect = False
.DefaultItemHeight = 48
With .Columns
With .Add("Group")
.set_Def(exontrol.EXG2ANTTLib.DefColumnEnum.exCellHasCheckBox,True)
.set_Def(exontrol.EXG2ANTTLib.DefColumnEnum.exCellBackColor,50331648)
.LevelKey = 1
End With
With .Add("Histogram")
.Width = 18
.AllowSizing = False
.LevelKey = 1
.Position = 0
End With
End With
With .Chart
.FirstVisibleDate = #6/11/2009#
.DrawGridLines = exontrol.EXG2ANTTLib.GridLinesEnum.exAllLines
.set_PaneWidth(False,96)
.LevelCount = 2
.DrawLevelSeparator = exontrol.EXG2ANTTLib.LevelLineEnum.exLevelNoLine
With .get_Level(0)
.Label = "<%mmmm%> <%yyyy%>"
.Unit = exontrol.EXG2ANTTLib.UnitEnum.exMonth
.Alignment = exontrol.EXG2ANTTLib.AlignmentEnum.CenterAlignment
End With
With .get_Level(1)
.FormatLabel = "weekday(dvalue)=1?value:''"
.DrawTickLines = exontrol.EXG2ANTTLib.LevelLineEnum.exLevelLowerHalf Or exontrol.EXG2ANTTLib.LevelLineEnum.exLevelSolidLine
.DrawTickLinesFrom(0,exontrol.EXG2ANTTLib.LevelLineEnum.exLevelSolidLine)
.Alignment = exontrol.EXG2ANTTLib.AlignmentEnum.CenterAlignment
End With
With .Bars.Item("Task")
.Color32 = &H2000000
.Height = 18
.OverlaidType = exontrol.EXG2ANTTLib.OverlaidBarsTypeEnum.exOverlaidBarsStackAutoArrange Or exontrol.EXG2ANTTLib.OverlaidBarsTypeEnum.exOverlaidBarsStack
.HistogramColor32 = &H1000000
.HistogramType = exontrol.EXG2ANTTLib.HistogramTypeEnum.exHistOverAllocation
End With
.HistogramVisible = True
.HistogramHeight = 48
.HistogramView = exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramCheckedItems
End With
With .Items
h = .AddItem("Group <b>A</b>")
.set_CellValueFormat(h,0,exontrol.EXG2ANTTLib.ValueFormatEnum.exHTML)
.set_CellMerge(h,0,1)
.AddBar(h,"Task",#6/12/2009#,#6/19/2009#,"K1","Requirements")
.AddBar(h,"Task",#6/13/2009#,#6/21/2009#,"K2","Sales & Marketing")
.set_ItemBar(h,"K1",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarColor,255)
.set_ItemBar(h,"K2",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarColor,255)
.set_CellState(h,0,1)
h = .AddItem("Group <b>B</b>")
.set_CellValueFormat(h,0,exontrol.EXG2ANTTLib.ValueFormatEnum.exHTML)
.set_CellMerge(h,0,1)
.AddBar(h,"Task",#6/14/2009#,#6/23/2009#,"K1","<b>GUI</b> Design")
.AddBar(h,"Task",#6/18/2009#,#6/25/2009#,"K2","Class Design")
h = .AddItem("Group <b>C</b>")
.set_CellValueFormat(h,0,exontrol.EXG2ANTTLib.ValueFormatEnum.exHTML)
.set_CellMerge(h,0,1)
.AddBar(h,"Task",#6/12/2009#,#6/19/2009#,"K1","<b>GUI</b> Coding")
.AddBar(h,"Task",#6/13/2009#,#6/25/2009#,"K2","Design & Concept")
.set_ItemBar(h,"K1",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarColor,65280)
.set_ItemBar(h,"K2",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarColor,65280)
End With
.EndUpdate()
End With
|
960
|
How can I remove all bars from the chart
With Exg2antt1
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
With .Items
.AddBar(.AddItem("Task 1"),"Task",#1/2/2001#,#1/4/2001#,"K1")
.AddBar(.AddItem("Task 2"),"Task",#1/2/2001#,#1/4/2001#,"K1")
.AddBar(.AddItem("Task 3"),"Task",#1/2/2001#,#1/4/2001#,"K1")
.AddBar(.AddItem("Task 4"),"Task",#1/2/2001#,#1/4/2001#,"K2")
.ClearBars(0)
End With
End With
|
959
|
How can I change the color for all bars with a specified key
With Exg2antt1
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
With .Items
.AddBar(.AddItem("Task 1"),"Task",#1/2/2001#,#1/4/2001#,"K1")
.AddBar(.AddItem("Task 2"),"Task",#1/2/2001#,#1/4/2001#,"K1")
.AddBar(.AddItem("Task 3"),"Task",#1/2/2001#,#1/4/2001#,"K1")
.AddBar(.AddItem("Task 4"),"Task",#1/2/2001#,#1/4/2001#,"K2")
.set_ItemBar(0,"K1",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarColor,255)
End With
End With
|
958
|
Is there any automatic way to change a property for all bars with a specified key
With Exg2antt1
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
With .Items
.AddBar(.AddItem("Task 1"),"Task",#1/2/2001#,#1/4/2001#,"K1")
.AddBar(.AddItem("Task 2"),"Task",#1/2/2001#,#1/4/2001#,"K1")
.AddBar(.AddItem("Task 3"),"Task",#1/2/2001#,#1/4/2001#,"K1")
.AddBar(.AddItem("Task 4"),"Task",#1/2/2001#,#1/4/2001#,"K2")
.set_ItemBar(0,"K1",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarColor,255)
End With
End With
|
957
|
How can I remove all bars with specified key
With Exg2antt1
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
With .Items
.AddBar(.AddItem("Task 1"),"Task",#1/2/2001#,#1/4/2001#,"K1")
.AddBar(.AddItem("Task 2"),"Task",#1/2/2001#,#1/4/2001#,"K1")
.AddBar(.AddItem("Task 3"),"Task",#1/2/2001#,#1/4/2001#,"K1")
.AddBar(.AddItem("Task 4"),"Task",#1/2/2001#,#1/4/2001#,"K2")
.RemoveBar(0,"K1")
End With
End With
|
956
|
How do I several bars with different vertical offsets

Dim h
With Exg2antt1
.Chart.FirstVisibleDate = #1/1/2001#
.Columns.Add("Column")
With .Items
h = .AddItem("Item")
.set_ItemHeight(h,62)
.AddBar(h,"Task",#1/2/2001#,#1/4/2001#,"T1")
.set_ItemBar(h,"T1",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarOffset,-23)
.AddBar(h,"Task",#1/2/2001#,#1/4/2001#,"T2")
.set_ItemBar(h,"T2",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarOffset,-11)
.AddBar(h,"Task",#1/2/2001#,#1/4/2001#,"T3")
.set_ItemBar(h,"T3",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarOffset,1)
.AddBar(h,"Task",#1/2/2001#,#1/4/2001#,"T4")
.set_ItemBar(h,"T4",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarOffset,13)
.AddBar(h,"Task",#1/2/2001#,#1/4/2001#,"T5")
.set_ItemBar(h,"T5",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarOffset,25)
End With
End With
|
955
|
Is there any option to show gradient bars without using EBN technology

Dim h
With Exg2antt1
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
With .Chart.Bars.Item("Task")
.Color = Color.FromArgb(255,0,0)
.StartColor = Color.FromArgb(0,255,0)
.EndColor = Color.FromArgb(255,255,0)
.Pattern = exontrol.EXG2ANTTLib.PatternEnum.exPatternBox
End With
With .Items
h = .AddItem("Task")
.AddBar(h,"Task",#1/2/2001#,#1/5/2001#,"")
End With
End With
|
954
|
How can I define a bar with border and solid filling

Dim h
With Exg2antt1
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
With .Chart.Bars.Item("Task")
.Color = Color.FromArgb(255,0,0)
.StartColor = Color.FromArgb(255,255,0)
.EndColor = Color.FromArgb(255,255,0)
.Pattern = exontrol.EXG2ANTTLib.PatternEnum.exPatternBox
End With
With .Items
h = .AddItem("Task")
.AddBar(h,"Task",#1/2/2001#,#1/5/2001#,"")
End With
End With
|
953
|
How can I define a bar with border and solid filling

Dim h
With Exg2antt1
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
With .Chart.Bars.Item("Task")
.Color = Color.FromArgb(255,0,0)
.Pattern = exontrol.EXG2ANTTLib.PatternEnum.exPatternBox
.Height = 18
End With
With .Items
h = .AddItem("Task")
.AddBar(h,"Task",#1/2/2001#,#1/5/2001#,"")
.set_ItemBar(h,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarBackColor,65535)
End With
End With
|
952
|
How do I define a bar with solid border and filling

Dim h
With Exg2antt1
.VisualAppearance.Add(1,"C:\Program Files\Exontrol\ExG2antt.NET\sample\EBN\blackboxt.ebn")
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
With .Chart.Bars.Item("Task")
.Color32 = &H1000000
.Height = 18
End With
With .Items
h = .AddItem("Task")
.AddBar(h,"Task",#1/2/2001#,#1/5/2001#,"")
.set_ItemBar(h,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarColor,255)
.set_ItemBar(h,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarBackColor,65535)
End With
End With
|
951
|
Can I control the units/resource/effort being allocated to a bar when displaying OverAllocation histogram

Dim h1
With Exg2antt1
.BeginUpdate()
.Columns.Add("Tasks")
With .Columns.Add("Effort")
.set_Def(exontrol.EXG2ANTTLib.DefColumnEnum.exCellValueToItemBarProperty,21)
.Editor.EditType = exontrol.EXG2ANTTLib.EditTypeEnum.SpinType
End With
With .Chart
.LevelCount = 2
.NonworkingDays = 0
.set_PaneWidth(False,96)
.FirstVisibleDate = #6/20/2005#
.HistogramVisible = True
.HistogramHeight = 202
.HistogramView = exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramAllItems
With .Bars.Item("Task")
.HistogramPattern = exontrol.EXG2ANTTLib.PatternEnum.exRectangularCurve Or exontrol.EXG2ANTTLib.PatternEnum.exPatternDot
.HistogramType = exontrol.EXG2ANTTLib.HistogramTypeEnum.exHistOverAllocation
.HistogramCriticalValue = 50
.HistogramGridLinesColor = Color.FromArgb(192,192,192)
.HistogramRulerLinesColor = Color.FromArgb(0,0,1)
End With
End With
With .Items
.AllowCellValueToItemBar = True
h1 = .AddItem("Task 1")
.AddBar(h1,"Task",#6/21/2005#,#6/25/2005#)
.set_CellValue(h1,1,2)
h1 = .AddItem("Task 2")
.AddBar(h1,"Task",#6/24/2005#,#6/28/2005#)
.set_CellValue(h1,1,1)
h1 = .AddItem("Task 3")
.AddBar(h1,"Task",#6/27/2005#,#7/1/2005#)
.set_CellValue(h1,1,2)
h1 = .AddItem("Task 4")
.AddBar(h1,"Task",#6/30/2005#,#7/2/2005#)
.set_CellValue(h1,1,1)
End With
.EndUpdate()
End With
|
950
|
Can I control the units/resource/effort being allocated to a bar when displaying Overload histogram

Dim h1
With Exg2antt1
.BeginUpdate()
.Columns.Add("Tasks")
With .Columns.Add("Effort")
.set_Def(exontrol.EXG2ANTTLib.DefColumnEnum.exCellValueToItemBarProperty,21)
.Editor.EditType = exontrol.EXG2ANTTLib.EditTypeEnum.SpinType
End With
With .Chart
.LevelCount = 2
.NonworkingDays = 0
.set_PaneWidth(False,96)
.FirstVisibleDate = #6/20/2005#
.HistogramVisible = True
.HistogramHeight = 128
.HistogramView = exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramAllItems
With .Bars.Item("Task")
.HistogramPattern = .Pattern
.HistogramType = exontrol.EXG2ANTTLib.HistogramTypeEnum.exHistOverload
.HistogramCriticalValue = 3
.ShowHistogramValues = "value>3?255:1"
.HistogramItems = -11
.HistogramGridLinesColor = Color.FromArgb(192,192,192)
.HistogramRulerLinesColor = Color.FromArgb(0,0,1)
End With
End With
With .Items
.AllowCellValueToItemBar = True
h1 = .AddItem("Task 1")
.AddBar(h1,"Task",#6/21/2005#,#6/23/2005#)
.set_CellValue(h1,1,4)
h1 = .AddItem("Task 2")
.AddBar(h1,"Task",#6/24/2005#,#6/26/2005#)
.set_CellValue(h1,1,3)
h1 = .AddItem("Task 3")
.AddBar(h1,"Task",#6/27/2005#,#6/29/2005#)
.set_CellValue(h1,1,2)
h1 = .AddItem("Task 4")
.AddBar(h1,"Task",#6/30/2005#,#7/2/2005#)
.set_CellValue(h1,1,1)
End With
.EndUpdate()
End With
|
949
|
How can I display double-lines curves in the histogram

With Exg2antt1
.AntiAliasing = True
With .Chart
.set_PaneWidth(False,48)
.FirstVisibleDate = #1/1/2001#
.HistogramVisible = True
.HistogramHeight = 64
With .Bars.Item("Task")
.HistogramPattern = exontrol.EXG2ANTTLib.PatternEnum.exBezierCurve
.HistogramItems = 3
.HistogramBorderColor = Color.FromArgb(128,0,0)
.HistogramColor = Color.FromArgb(255,0,0)
End With
End With
.Columns.Add("Column")
With .Items
.AddBar(.AddItem("Item 1"),"Task",#1/2/2001#,#1/4/2001#)
.AddBar(.AddItem("Item 2"),"Task",#1/3/2001#,#1/7/2001#)
End With
End With
|
948
|
Is there any option to display values in the histogram using different colors

With Exg2antt1
With .Chart
.FirstVisibleDate = #1/1/2001#
.HistogramVisible = True
.HistogramHeight = 32
With .Bars.Item("Task")
.HistogramPattern = exontrol.EXG2ANTTLib.PatternEnum.exPatternBDiagonal
.HistogramItems = 6
.ShowHistogramValues = "value>1?255:65280"
End With
End With
.Columns.Add("Column")
With .Items
.AddBar(.AddItem("Item 1"),"Task",#1/2/2001#,#1/4/2001#)
.AddBar(.AddItem("Item 1"),"Task",#1/3/2001#,#1/7/2001#)
End With
End With
|
947
|
Is there any option to display values in the histogram using different colors

With Exg2antt1
With .Chart
.FirstVisibleDate = #1/1/2001#
.HistogramVisible = True
.HistogramHeight = 32
With .Bars.Item("Task")
.HistogramPattern = exontrol.EXG2ANTTLib.PatternEnum.exPatternBDiagonal
.HistogramItems = 6
.ShowHistogramValues = "value>1?255:1"
End With
End With
.Columns.Add("Column")
With .Items
.AddBar(.AddItem("Item 1"),"Task",#1/2/2001#,#1/4/2001#)
.AddBar(.AddItem("Item 1"),"Task",#1/3/2001#,#1/7/2001#)
End With
End With
|
946
|
How can I display only few values in the histogram, such as the values greater than a value

With Exg2antt1
With .Chart
.FirstVisibleDate = #1/1/2001#
.HistogramVisible = True
.HistogramHeight = 32
With .Bars.Item("Task")
.HistogramPattern = exontrol.EXG2ANTTLib.PatternEnum.exPatternBDiagonal
.ShowHistogramValues = "value>1"
End With
End With
.Columns.Add("Column")
With .Items
.AddBar(.AddItem("Item 1"),"Task",#1/2/2001#,#1/4/2001#)
.AddBar(.AddItem("Item 1"),"Task",#1/3/2001#,#1/7/2001#)
End With
End With
|
945
|
How can I display values in the histogram

With Exg2antt1
With .Chart
.FirstVisibleDate = #1/1/2001#
.HistogramVisible = True
.HistogramHeight = 32
With .Bars.Item("Task")
.HistogramPattern = exontrol.EXG2ANTTLib.PatternEnum.exPatternBDiagonal
.ShowHistogramValues = "1"
End With
End With
.Columns.Add("Column")
With .Items
.AddBar(.AddItem("Item 1"),"Task",#1/2/2001#,#1/4/2001#)
.AddBar(.AddItem("Item 1"),"Task",#1/3/2001#,#1/7/2001#)
End With
End With
|
944
|
How can I scroll the chart to find a bar
Dim h
With Exg2antt1
.Columns.Add("Column")
.Chart.LevelCount = 2
.Chart.set_PaneWidth(False,64)
.DefaultItemHeight = 32
With .Items
.AddBar(.AddItem("Item 1"),"Task",#1/2/2001#,#1/4/2001#,1)
.AddBar(.AddItem("Item 2"),"Task",#1/2/2001#,#1/4/2001#,2)
.AddBar(.AddItem("Item 3"),"Task",#1/2/2001#,#1/4/2001#,3)
.AddBar(.AddItem("Item 4"),"Task",#1/2/2001#,#1/4/2001#,4)
.AddBar(.AddItem("Item 5"),"Task",#1/2/2001#,#1/4/2001#,5)
.AddBar(.AddItem("Item 6"),"Task",#1/2/2001#,#1/4/2001#,6)
.AddBar(.AddItem("Item 7"),"Task",#1/2/2001#,#1/4/2001#,7)
.AddBar(.AddItem("Item 8"),"Task",#1/2/2001#,#1/4/2001#,8)
.AddBar(.AddItem("Item 9"),"Task",#1/2/2001#,#1/4/2001#,8)
.AddBar(.AddItem("Item 10"),"Task",#1/2/2001#,#1/4/2001#,10)
.AddBar(.AddItem("Item 11"),"Task",#1/2/2001#,#1/4/2001#,11)
.AddBar(.AddItem("Item 12"),"Task",#1/2/2001#,#1/4/2001#,12)
.AddBar(.AddItem("Item 13"),"Task",#1/2/2001#,#1/4/2001#,13)
.AddBar(.AddItem("Item 14"),"Task",#1/2/2001#,#1/4/2001#,14)
End With
h = .Items.get_FindBar(14)
.Items.EnsureVisibleItem(h)
.Chart.ScrollTo(Exg2antt1.Items.get_ItemBar(h,14,exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarStart),1)
End With
|
943
|
Can I change the color/marker/frame for selected bars

Dim h
With Exg2antt1
.BeginUpdate()
With .VisualAppearance
.Add(2,"c:\exontrol\images\normal.ebn")
.Add(1,"CP:2 3 2 -3 -2")
End With
With .Chart
.FirstVisibleDate = #1/1/2002#
.SelBarColor32 = &H1000000
.set_PaneWidth(False,48)
End With
.Columns.Add("Task")
With .Items
h = .AddItem("Task 1")
.AddBar(h,"Task",#1/2/2002#,#1/4/2002#,"A")
.AddBar(h,"Task",#1/6/2002#,#1/10/2002#,"B")
.AddBar(h,"Task",#1/11/2002#,#1/14/2002#,"C")
.set_ItemBar(h,"A",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarSelected,True)
.set_ItemBar(h,"B",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarSelected,True)
End With
.EndUpdate()
End With
|
942
|
Can I display a larger marker for selected bars, eventually using the EBN technology

Dim h
With Exg2antt1
.BeginUpdate()
.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
With .Chart
.FirstVisibleDate = #1/1/2002#
.SelBarColor32 = &H1000000
.set_PaneWidth(False,48)
End With
.Columns.Add("Task")
With .Items
h = .AddItem("Task 1")
.AddBar(h,"Task",#1/2/2002#,#1/4/2002#,"A")
.AddBar(h,"Task",#1/6/2002#,#1/10/2002#,"B")
.AddBar(h,"Task",#1/11/2002#,#1/14/2002#,"C")
.set_ItemBar(h,"A",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarSelected,True)
.set_ItemBar(h,"B",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarSelected,True)
End With
.EndUpdate()
End With
|
941
|
How do I change the color for the selected bars

Dim h
With Exg2antt1
.BeginUpdate()
.Debug = True
With .Chart
.FirstVisibleDate = #1/1/2002#
.SelBarColor = Color.FromArgb(255,0,0)
.set_PaneWidth(False,48)
End With
.Columns.Add("Task")
With .Items
h = .AddItem("Task 1")
.AddBar(h,"Task",#1/2/2002#,#1/4/2002#,"A")
.AddBar(h,"Task",#1/6/2002#,#1/10/2002#,"B")
.AddBar(h,"Task",#1/11/2002#,#1/14/2002#,"C")
.set_ItemBar(h,"A",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarSelected,True)
.set_ItemBar(h,"B",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarSelected,True)
End With
.EndUpdate()
End With
|
940
|
How can I change the background color for child bars of a summary bar

Dim h1,hR1
With Exg2antt1
.BeginUpdate()
.LinesAtRoot = exontrol.EXG2ANTTLib.LinesAtRootEnum.exLinesAtRoot
.HasLines = exontrol.EXG2ANTTLib.HierarchyLineEnum.exNoLine
With .Chart
.AllowCreateBar = exontrol.EXG2ANTTLib.CreateBarEnum.exNoCreateBar
.AllowLinkBars = False
.FirstVisibleDate = #1/1/2008#
.LevelCount = 2
.set_PaneWidth(False,112)
End With
.Columns.Add("")
With .Items
hR1 = .AddItem("Team 1")
.AddBar(hR1,"Summary",#1/2/2008#,#1/8/2008#,"")
.set_ItemBar(hR1,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exSummaryBarBackColor,12895428)
h1 = .InsertItem(hR1,Nothing,"Member 1")
.AddBar(h1,"Task",#1/2/2008#,#1/7/2008#)
.DefineSummaryBars(hR1,"",h1,"")
h1 = .InsertItem(hR1,Nothing,"Member 2")
.AddBar(h1,"Task",#1/4/2008#,#1/9/2008#)
.DefineSummaryBars(hR1,"",h1,"")
h1 = .InsertItem(hR1,Nothing,"Member 3")
.AddBar(h1,"Task",#1/5/2008#,#1/10/2008#)
.DefineSummaryBars(hR1,"",h1,"")
.set_ExpandItem(hR1,True)
End With
.EndUpdate()
End With
|
939
|
How can I allow resizing the bar only in the right part of the bar
Dim h
With Exg2antt1
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
With .Items
h = .AddItem("Task 1")
.AddBar(h,"Task",#1/2/2001#,#1/6/2001#,"K1")
.set_ItemBar(h,"K1",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarCanResize,2)
End With
End With
|
938
|
How can I allow resizing the bar only in the left part of the bar
Dim h
With Exg2antt1
.Columns.Add("Task")
.Chart.FirstVisibleDate = #1/1/2001#
With .Items
h = .AddItem("Task 1")
.AddBar(h,"Task",#1/2/2001#,#1/6/2001#,"K1")
.set_ItemBar(h,"K1",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarCanResize,1)
End With
End With
|
937
|
How can I show the links that starts from selected bar being more visible, while the rest being transparent

Dim h1,h2,h3
With Exg2antt1
.BeginUpdate()
.Columns.Add("Tasks")
With .Chart
.FirstVisibleDate = #9/20/2006#
.set_PaneWidth(False,64)
.set_ShowLinksWidth(exontrol.EXG2ANTTLib.ShowLinksEnum.exShowLinksStartFrom,2)
.set_ShowLinksStyle(exontrol.EXG2ANTTLib.ShowLinksEnum.exShowLinksStartFrom,exontrol.EXG2ANTTLib.LinkStyleEnum.exLinkDot)
.set_ShowLinksColor(exontrol.EXG2ANTTLib.ShowLinksEnum.exShowLinksEndTo,Color.FromArgb(200,200,200))
.set_ShowLinksColor(exontrol.EXG2ANTTLib.ShowLinksEnum.exShowUnselectedLinks,Color.FromArgb(200,200,200))
End With
With .Items
h1 = .AddItem("Task 1")
.AddBar(h1,"Task",#9/21/2006#,#9/23/2006#)
h2 = .AddItem("Task 2")
.AddBar(h2,"Task",#9/25/2006#,#9/27/2006#)
.set_ItemBar(h2,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarSelected,True)
.AddLink("L1",h1,"",h2,"")
.set_Link("L1",exontrol.EXG2ANTTLib.LinkPropertyEnum.exLinkText,"L1")
h3 = .AddItem("Task 3")
.AddBar(h3,"Task",#9/29/2006#,#10/2/2006#)
.AddLink("L2",h2,"",h3,"")
.set_Link("L2",exontrol.EXG2ANTTLib.LinkPropertyEnum.exLinkText,"L2")
End With
.EndUpdate()
End With
|
936
|
How can I show only the links that starts from selected bar

Dim h,h1,h2,h3
With Exg2antt1
.BeginUpdate()
.MarkSearchColumn = False
.OnResizeControl = exontrol.EXG2ANTTLib.OnResizeControlEnum.exResizeChart
.Columns.Add("Tasks")
.Columns.Add("Start").Visible = False
.Columns.Add("End").Visible = False
With .Chart
.FirstVisibleDate = #9/20/2006#
.set_PaneWidth(False,64)
.set_ShowLinksColor(exontrol.EXG2ANTTLib.ShowLinksEnum.exShowLinksEndTo,.BackColor)
.set_ShowLinksColor(exontrol.EXG2ANTTLib.ShowLinksEnum.exShowUnselectedLinks,.BackColor)
End With
With .Items
h1 = .AddItem("Task 1")
.set_CellValue(h1,1,#9/21/2006#)
.set_CellValue(h1,2,#9/24/2006#)
.AddBar(h1,"Task",.get_CellValue(h1,1),.get_CellValue(h1,2))
h2 = .InsertItem(h,Nothing,"Task 2")
.set_CellValue(h2,1,#9/25/2006#)
.set_CellValue(h2,2,#9/28/2006#)
.AddBar(h2,"Task",.get_CellValue(h2,1),.get_CellValue(h2,2))
.set_ItemBar(h2,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarSelected,True)
.AddLink("L1",h1,"",h2,"")
h3 = .InsertItem(h,Nothing,"Task 3")
.set_CellValue(h3,1,#9/29/2006#)
.set_CellValue(h3,2,#10/2/2006#)
.AddBar(h3,"Task",.get_CellValue(h3,1),.get_CellValue(h3,2))
.AddLink("L2",h2,"",h3,"")
End With
.EndUpdate()
End With
|
935
|
How can I hide links that are not related to selected bar

Dim h,h1,h2,h3
With Exg2antt1
.BeginUpdate()
.MarkSearchColumn = False
.OnResizeControl = exontrol.EXG2ANTTLib.OnResizeControlEnum.exResizeChart
.Columns.Add("Tasks")
.Columns.Add("Start").Visible = False
.Columns.Add("End").Visible = False
With .Chart
.FirstVisibleDate = #9/20/2006#
.set_PaneWidth(False,64)
.set_ShowLinksColor(exontrol.EXG2ANTTLib.ShowLinksEnum.exShowUnselectedLinks,.BackColor)
End With
With .Items
h1 = .AddItem("Task 1")
.set_CellValue(h1,1,#9/21/2006#)
.set_CellValue(h1,2,#9/24/2006#)
.AddBar(h1,"Task",.get_CellValue(h1,1),.get_CellValue(h1,2))
.set_ItemBar(h1,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarSelected,True)
h2 = .InsertItem(h,Nothing,"Task 2")
.set_CellValue(h2,1,#9/25/2006#)
.set_CellValue(h2,2,#9/28/2006#)
.AddBar(h2,"Task",.get_CellValue(h2,1),.get_CellValue(h2,2))
.AddLink("L1",h1,"",h2,"")
h3 = .InsertItem(h,Nothing,"Task 3")
.set_CellValue(h3,1,#9/29/2006#)
.set_CellValue(h3,2,#10/2/2006#)
.AddBar(h3,"Task",.get_CellValue(h3,1),.get_CellValue(h3,2))
.AddLink("L2",h2,"",h3,"")
End With
.EndUpdate()
End With
|
934
|
How can I show the direction of the link using EBN files

Dim h1,h2
With Exg2antt1
.BeginUpdate()
With .VisualAppearance
.Add(1,"c:\exontrol\images\normal.ebn")
.Add(2,"CP:1 -1 -1 1 1")
.Add(3,"CP:1 -2 -2 2 2")
End With
With .Chart
.FirstVisibleDate = #1/1/2001#
.set_PaneWidth(False,128)
End With
.Columns.Add("Column")
With .Items
h1 = .AddItem("Task 1")
.AddBar(h1,"Task",#1/2/2001#,#1/4/2001#,"B1")
h2 = .AddItem("Task 2")
.AddBar(h2,"Task",#1/5/2001#,#1/13/2001#,"B2")
.AddLink("L1",h1,"B1",h2,"B2")
.set_Link("L1",exontrol.EXG2ANTTLib.LinkPropertyEnum.exLinkArrowColor,16777216)
h2 = .AddItem("Task 3")
.AddBar(h2,"Task",#1/5/2001#,#1/13/2001#,"B3")
.AddLink("L2",h1,"B1",h2,"B3")
.set_Link("L2",exontrol.EXG2ANTTLib.LinkPropertyEnum.exLinkArrowColor,33554432)
h2 = .AddItem("Task 4")
.AddBar(h2,"Task",#1/5/2001#,#1/13/2001#,"B5")
.AddLink("L3",h1,"B1",h2,"B5")
.set_Link("L3",exontrol.EXG2ANTTLib.LinkPropertyEnum.exLinkArrowColor,50331648)
End With
.EndUpdate()
End With
|
933
|
How can I show round links

With Exg2antt1
.Chart.FirstVisibleDate = #1/1/2001#
.Columns.Add("Column")
With .Items
.AddBar(.AddItem("Item 1"),"Task",#1/2/2001#,#1/4/2001#,"B1")
.AddBar(.AddItem("Item 2"),"Task",#1/5/2001#,#1/13/2001#,"B2")
.AddLink("L1",.get_FindItem("Item 1",0),"B1",.get_FindItem("Item 2",0),"B2")
.set_Link("L1",exontrol.EXG2ANTTLib.LinkPropertyEnum.exLinkShowRound,True)
End With
End With
|
932
|
How can I change the color to display the arrow of the link

With Exg2antt1
.Chart.FirstVisibleDate = #1/1/2001#
.Columns.Add("Column")
With .Items
.AddBar(.AddItem("Item 1"),"Task",#1/2/2001#,#1/4/2001#,"B1")
.AddBar(.AddItem("Item 2"),"Task",#1/6/2001#,#1/14/2001#,"B2")
.AddLink("L1",.get_FindItem("Item 1",0),"B1",.get_FindItem("Item 2",0),"B2")
.set_Link("L1",exontrol.EXG2ANTTLib.LinkPropertyEnum.exLinkArrowColor,255)
End With
End With
|
931
|
I use UnitScale: exHour and I want to show only from 9 to 18 hour. The idea is to show only the working part of a day. Is this possible

With Exg2antt1
.BeginUpdate()
With .Chart
.MarkTodayColor = .BackColor
.BackColorLevelHeader = Color.FromArgb(255,255,255)
.set_PaneWidth(False,0)
.LevelCount = 2
With .get_Level(0)
.Label = "<b><%dddd%></b> <%d%>"
.Alignment = exontrol.EXG2ANTTLib.AlignmentEnum.CenterAlignment
.DrawTickLines = exontrol.EXG2ANTTLib.LevelLineEnum.exLevelNoLine
End With
With .get_Level(1)
.Label = 65536
.DrawTickLines = exontrol.EXG2ANTTLib.LevelLineEnum.exLevelMiddleLine Or exontrol.EXG2ANTTLib.LevelLineEnum.exLevelDotLine
.DrawTickLinesFrom(0,exontrol.EXG2ANTTLib.LevelLineEnum.exLevelDotLine)
End With
.NonworkingHours = 16253439
.ShowNonworkingUnits = False
.ShowNonworkingDates = False
.ShowNonworkingHours = False
End With
.EndUpdate()
End With
|
930
|
Can I display tick lines from other level to my base level so time units gets separated more clearly

With Exg2antt1
.BeginUpdate()
With .Chart
.DrawLevelSeparator = exontrol.EXG2ANTTLib.LevelLineEnum.exLevelNoLine
.UnitWidth = 24
.FirstVisibleDate = #1/1/2001#
.set_PaneWidth(False,0)
.LevelCount = 2
With .get_Level(0)
.Alignment = exontrol.EXG2ANTTLib.AlignmentEnum.CenterAlignment
.Label = "<%dddd%>"
.DrawTickLines = exontrol.EXG2ANTTLib.LevelLineEnum.exLevelLowerHalf Or exontrol.EXG2ANTTLib.LevelLineEnum.exLevelSolidLine
End With
With .get_Level(1)
.Label = 65536
.Count = 6
.DrawTickLines = exontrol.EXG2ANTTLib.LevelLineEnum.exLevelMiddleLine Or exontrol.EXG2ANTTLib.LevelLineEnum.exLevelSolidLine
.DrawTickLinesFrom(0,exontrol.EXG2ANTTLib.LevelLineEnum.exLevelSolidLine)
End With
End With
.EndUpdate()
End With
|
929
|
Is there any property to change the style of the tick lines being shown in the chart

With Exg2antt1
.BeginUpdate()
With .Chart
.UnitWidth = 24
.FirstVisibleDate = #1/1/2001#
.set_PaneWidth(False,0)
.LevelCount = 2
With .get_Level(0)
.Alignment = exontrol.EXG2ANTTLib.AlignmentEnum.CenterAlignment
.Label = "<%dddd%>"
.DrawTickLines = exontrol.EXG2ANTTLib.LevelLineEnum.exLevelSolidLine
End With
With .get_Level(1)
.Label = 65536
.Count = 6
.DrawTickLines = exontrol.EXG2ANTTLib.LevelLineEnum.exLevelUpperHalf Or exontrol.EXG2ANTTLib.LevelLineEnum.exLevelSolidLine
End With
.DrawLevelSeparator = exontrol.EXG2ANTTLib.LevelLineEnum.exLevelSolidLine
End With
.EndUpdate()
End With
|
928
|
Is there any property to change the style of the tick lines being shown in the chart

With Exg2antt1
.BeginUpdate()
With .Chart
.FirstVisibleDate = #1/1/2001#
.set_PaneWidth(False,0)
.LevelCount = 2
.DrawLevelSeparator = exontrol.EXG2ANTTLib.LevelLineEnum.exLevelSolidLine
With .get_Level(0)
.Label = "<%dddd%>"
.DrawTickLines = exontrol.EXG2ANTTLib.LevelLineEnum.exLevelSolidLine
End With
With .get_Level(1)
.Label = 65536
.Count = 6
.DrawTickLines = exontrol.EXG2ANTTLib.LevelLineEnum.exLevelSolidLine
End With
End With
.EndUpdate()
End With
|
927
|
How can I show the levels based on the base level so tick lines aligns better

With Exg2antt1
.BeginUpdate()
With .Chart
.AdjustLevelsToBase = True
.UnitWidth = 24
.FirstVisibleDate = #1/1/2001#
.set_PaneWidth(False,0)
.LevelCount = 2
.get_Level(0).Label = "<%dddd%>"
With .get_Level(1)
.Label = 65536
.Count = 5
End With
End With
.EndUpdate()
End With
|
926
|
How can I show only working hours in other words only the working part of the day

With Exg2antt1
.BeginUpdate()
With .Chart
.AllowSelectDate = exontrol.EXG2ANTTLib.SelectDateEnum.exNoSelectDate
.MarkTodayColor = .BackColor
.set_PaneWidth(False,0)
.LevelCount = 2
With .get_Level(0)
.Label = "<b><%dddd%></b> <%d%>"
.Alignment = exontrol.EXG2ANTTLib.AlignmentEnum.CenterAlignment
.DrawTickLines = exontrol.EXG2ANTTLib.LevelLineEnum.exLevelNoLine
End With
With .get_Level(1)
.Label = 65536
.set_ReplaceLabel("09","<fgcolor=FF0000><b><font ;10>9</font></b></fgcolor>")
End With
.NonworkingHours = 16253439
.ShowNonworkingUnits = False
.ShowNonworkingDates = False
.ShowNonworkingHours = False
End With
.EndUpdate()
End With
|
925
|
How can I specify the effort for bars when displaying the overload histogram

Dim h1
With Exg2antt1
.BeginUpdate()
.Columns.Add("Tasks")
With .Chart
.LevelCount = 2
.NonworkingDays = 0
.set_PaneWidth(False,52)
.FirstVisibleDate = #6/20/2005#
.HistogramVisible = True
.HistogramHeight = 64
.HistogramView = exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramAllItems
With .Bars.Item("Task")
.HistogramPattern = .Pattern
.HistogramType = exontrol.EXG2ANTTLib.HistogramTypeEnum.exHistOverload
.HistogramItems = -6
.HistogramGridLinesColor = Color.FromArgb(192,192,192)
.HistogramRulerLinesColor = Color.FromArgb(0,0,1)
End With
End With
With .Items
h1 = .AddItem("Task 1")
.AddBar(h1,"Task",#6/21/2005#,#6/23/2005#,"","4")
.set_ItemBar(h1,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarEffort,4)
h1 = .AddItem("Task 2")
.AddBar(h1,"Task",#6/24/2005#,#6/26/2005#,"",3)
.set_ItemBar(h1,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarEffort,3)
h1 = .AddItem("Task 3")
.AddBar(h1,"Task",#6/27/2005#,#6/29/2005#,"",2)
.set_ItemBar(h1,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarEffort,2)
h1 = .AddItem("Task 4")
.AddBar(h1,"Task",#6/30/2005#,#7/2/2005#,"",1)
End With
.EndUpdate()
End With
|
924
|
How can I display the cumulative histogram and showing the bars that generated it using different colors

Dim h
With Exg2antt1
.BeginUpdate()
With .Chart
.FirstVisibleDate = #1/1/2001#
.HistogramVisible = True
.HistogramHeight = 64
.set_PaneWidth(False,128)
.HistogramView = exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramNoGrouping Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramLeafItems Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramUnlockedItems Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramCheckedItems
With .Bars.Item("Task")
.HistogramPattern = exontrol.EXG2ANTTLib.PatternEnum.exPatternSolid
.HistogramType = exontrol.EXG2ANTTLib.HistogramTypeEnum.exHistCumulative
.HistogramCumulativeOriginalColorBars = exontrol.EXG2ANTTLib.HistogramCumulativeOriginalColorBarsEnum.exChangeColor
.HistogramItems = 6
.HistogramRulerLinesColor = Color.FromArgb(128,0,0)
.HistogramBorderColor = Color.FromArgb(1,0,0)
End With
End With
With .Columns.Add("Column")
.set_Def(exontrol.EXG2ANTTLib.DefColumnEnum.exCellHasCheckBox,True)
.PartialCheck = True
End With
With .Items
h = .AddItem("Project 1")
.AddBar(.InsertItem(h,Nothing,"Item 1"),"Task",#1/2/2001#,#1/4/2001#)
.AddBar(.InsertItem(h,Nothing,"Item 2"),"Task",#1/3/2001#,#1/5/2001#)
.AddBar(.InsertItem(h,Nothing,"Item 3"),"Task",#1/4/2001#,#1/6/2001#)
.AddBar(.InsertItem(h,Nothing,"Item 4"),"Task",#1/2/2001#,#1/8/2001#)
.set_CellState(.get_ItemByIndex(1),0,1)
.set_ExpandItem(h,True)
End With
.EndUpdate()
End With
|
923
|
How can I show the cumulative histogram for my bar

Dim h
With Exg2antt1
.BeginUpdate()
With .Chart
.FirstVisibleDate = #1/1/2001#
.HistogramVisible = True
.HistogramHeight = 64
.set_PaneWidth(False,128)
.HistogramView = exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramNoGrouping Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramLeafItems Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramUnlockedItems Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramCheckedItems
With .Bars.Item("Task")
.HistogramPattern = exontrol.EXG2ANTTLib.PatternEnum.exPatternSolid
.HistogramType = exontrol.EXG2ANTTLib.HistogramTypeEnum.exHistCumulative
.HistogramItems = 6
.HistogramRulerLinesColor = Color.FromArgb(128,0,0)
.HistogramBorderColor = Color.FromArgb(1,0,0)
End With
End With
With .Columns.Add("Column")
.set_Def(exontrol.EXG2ANTTLib.DefColumnEnum.exCellHasCheckBox,True)
.PartialCheck = True
End With
With .Items
h = .AddItem("Project 1")
.AddBar(.InsertItem(h,Nothing,"Item 1"),"Task",#1/2/2001#,#1/4/2001#)
.AddBar(.InsertItem(h,Nothing,"Item 2"),"Task",#1/3/2001#,#1/5/2001#)
.AddBar(.InsertItem(h,Nothing,"Item 3"),"Task",#1/4/2001#,#1/6/2001#)
.AddBar(.InsertItem(h,Nothing,"Item 4"),"Task",#1/2/2001#,#1/8/2001#)
.set_CellState(.get_ItemByIndex(1),0,1)
.set_ExpandItem(h,True)
End With
.EndUpdate()
End With
|
922
|
How can I show some grid lines or ruler in the histogram

Dim h
With Exg2antt1
With .Chart
.FirstVisibleDate = #1/1/2001#
.HistogramVisible = True
.HistogramHeight = 64
.set_PaneWidth(False,78)
.HistogramView = exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramNoGrouping Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramLeafItems Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramUnlockedItems Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramCheckedItems
With .Bars.Item("Task")
.HistogramPattern = exontrol.EXG2ANTTLib.PatternEnum.exPatternBDiagonal
.HistogramItems = 6
.HistogramRulerLinesColor = Color.FromArgb(128,0,0)
.HistogramGridLinesColor = Color.FromArgb(255,0,0)
End With
End With
.Columns.Add("Column")
With .Items
h = .AddItem("Project 1")
.set_CellHasCheckBox(h,0,True)
.set_CellState(h,0,1)
.AddBar(.InsertItem(h,Nothing,"Item 1"),"Task",#1/2/2001#,#1/4/2001#)
.AddBar(.InsertItem(h,Nothing,"Item 2"),"Task",#1/3/2001#,#1/5/2001#)
.set_ExpandItem(h,True)
End With
End With
|
921
|
Is there any property to show some grid lines in the histogram

Dim h
With Exg2antt1
With .Chart
.FirstVisibleDate = #1/1/2001#
.HistogramVisible = True
.HistogramHeight = 64
.set_PaneWidth(False,78)
.HistogramView = exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramNoGrouping Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramLeafItems Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramUnlockedItems Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramCheckedItems
With .Bars.Item("Task")
.HistogramPattern = exontrol.EXG2ANTTLib.PatternEnum.exPatternBDiagonal
.HistogramItems = 6
.HistogramGridLinesColor = Color.FromArgb(255,0,0)
End With
End With
.Columns.Add("Column")
With .Items
h = .AddItem("Project 1")
.set_CellHasCheckBox(h,0,True)
.set_CellState(h,0,1)
.AddBar(.InsertItem(h,Nothing,"Item 1"),"Task",#1/2/2001#,#1/4/2001#)
.AddBar(.InsertItem(h,Nothing,"Item 2"),"Task",#1/3/2001#,#1/5/2001#)
.set_ExpandItem(h,True)
End With
End With
|
920
|
How can I specify a fixed number of bars/items being shown in the histogram

Dim h
With Exg2antt1
With .Chart
.FirstVisibleDate = #1/1/2001#
.HistogramVisible = True
.HistogramHeight = 64
.set_PaneWidth(False,78)
.HistogramView = exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramNoGrouping Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramLeafItems Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramUnlockedItems Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramCheckedItems
With .Bars.Item("Task")
.HistogramPattern = exontrol.EXG2ANTTLib.PatternEnum.exPatternBDiagonal
.HistogramCriticalValue = 3
.HistogramItems = -6
.HistogramRulerLinesColor = Color.FromArgb(1,0,0)
End With
End With
.Columns.Add("Column")
With .Items
h = .AddItem("Project 1")
.set_CellHasCheckBox(h,0,True)
.set_CellState(h,0,1)
.AddBar(.InsertItem(h,Nothing,"Item 1"),"Task",#1/2/2001#,#1/4/2001#)
.AddBar(.InsertItem(h,Nothing,"Item 2"),"Task",#1/3/2001#,#1/5/2001#)
.set_ExpandItem(h,True)
h = .AddItem("Project 2")
.set_CellHasCheckBox(h,0,True)
.set_CellState(h,0,1)
.AddBar(.InsertItem(h,Nothing,"Item 1"),"Task",#1/4/2001#,#1/7/2001#)
.AddBar(.InsertItem(h,Nothing,"Item 2"),"Task",#1/6/2001#,#1/8/2001#)
.set_ExpandItem(h,True)
h = .AddItem("Project 3")
.set_CellHasCheckBox(h,0,True)
.set_CellState(h,0,1)
.AddBar(.InsertItem(h,Nothing,"Item 1"),"Task",#1/2/2001#,#1/4/2001#)
.AddBar(.InsertItem(h,Nothing,"Item 2"),"Task",#1/3/2001#,#1/5/2001#)
.set_ExpandItem(h,True)
h = .AddItem("Project 4")
.set_CellHasCheckBox(h,0,True)
.set_CellState(h,0,1)
.AddBar(.InsertItem(h,Nothing,"Item 1"),"Task",#1/4/2001#,#1/7/2001#)
.AddBar(.InsertItem(h,Nothing,"Item 2"),"Task",#1/6/2001#,#1/8/2001#)
.set_ExpandItem(h,True)
End With
End With
|
919
|
Is there any option to specify a minimum number of bars/items displayed in the histogram

Dim h
With Exg2antt1
With .Chart
.FirstVisibleDate = #1/1/2001#
.HistogramVisible = True
.HistogramHeight = 64
.set_PaneWidth(False,78)
.HistogramView = exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramNoGrouping Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramLeafItems Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramUnlockedItems Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramCheckedItems
With .Bars.Item("Task")
.HistogramPattern = exontrol.EXG2ANTTLib.PatternEnum.exPatternBDiagonal
.HistogramItems = 6
.HistogramGridLinesColor = Color.FromArgb(1,0,0)
.HistogramRulerLinesColor = Color.FromArgb(1,0,0)
End With
End With
.Columns.Add("Column")
With .Items
h = .AddItem("Project 1")
.set_CellHasCheckBox(h,0,True)
.set_CellState(h,0,1)
.AddBar(.InsertItem(h,Nothing,"Item 1"),"Task",#1/2/2001#,#1/4/2001#)
.AddBar(.InsertItem(h,Nothing,"Item 2"),"Task",#1/3/2001#,#1/5/2001#)
.set_ExpandItem(h,True)
h = .AddItem("Project 2")
.set_CellHasCheckBox(h,0,True)
.set_CellState(h,0,1)
.AddBar(.InsertItem(h,Nothing,"Item 1"),"Task",#1/4/2001#,#1/7/2001#)
.AddBar(.InsertItem(h,Nothing,"Item 2"),"Task",#1/6/2001#,#1/8/2001#)
.set_ExpandItem(h,True)
End With
End With
|
918
|
How can I show the histogram without grouping the bars based on their parents

Dim h
With Exg2antt1
With .Chart
.FirstVisibleDate = #1/1/2001#
.HistogramVisible = True
.HistogramHeight = 32
.HistogramView = exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramNoGrouping Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramLeafItems Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramUnlockedItems Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramCheckedItems
.Bars.Item("Task").HistogramPattern = exontrol.EXG2ANTTLib.PatternEnum.exPatternBDiagonal
End With
.Columns.Add("Column")
With .Items
h = .AddItem("Project 1")
.set_CellHasCheckBox(h,0,True)
.set_CellState(h,0,1)
.AddBar(.InsertItem(h,Nothing,"Item 1"),"Task",#1/2/2001#,#1/4/2001#)
.AddBar(.InsertItem(h,Nothing,"Item 2"),"Task",#1/3/2001#,#1/5/2001#)
.set_ExpandItem(h,True)
h = .AddItem("Project 2")
.set_CellHasCheckBox(h,0,True)
.set_CellState(h,0,1)
.AddBar(.InsertItem(h,Nothing,"Item 1"),"Task",#1/4/2001#,#1/7/2001#)
.AddBar(.InsertItem(h,Nothing,"Item 2"),"Task",#1/6/2001#,#1/8/2001#)
.set_ExpandItem(h,True)
End With
End With
|
917
|
How can I show the histogram for checked item and all recursively child items

Dim h
With Exg2antt1
.BeginUpdate()
With .Chart
.set_PaneWidth(False,128)
.FirstVisibleDate = #1/1/2001#
.HistogramVisible = True
.HistogramHeight = 128
.HistogramView = exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramRecLeafItems Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramLeafItems Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramUnlockedItems Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramCheckedItems
.Bars.Item("Task").HistogramPattern = exontrol.EXG2ANTTLib.PatternEnum.exPatternBDiagonal
End With
.Columns.Add("Column")
With .Items
h = .AddItem("Project")
.set_CellHasCheckBox(h,0,True)
.set_CellState(h,0,1)
.AddBar(.InsertItem(h,Nothing,"Item 1"),"Task",#1/2/2001#,#1/4/2001#)
.AddBar(.InsertItem(h,Nothing,"Item 2"),"Task",#1/3/2001#,#1/5/2001#)
.set_ExpandItem(h,True)
h = .InsertItem(h,Nothing,"SubProject")
.AddBar(.InsertItem(h,Nothing,"Item 1"),"Task",#1/3/2001#,#1/7/2001#)
.AddBar(.InsertItem(h,Nothing,"Item 2"),"Task",#1/5/2001#,#1/8/2001#)
.set_ExpandItem(h,True)
End With
.EndUpdate()
End With
|
916
|
How can I show the histogram for checked item and its child items

Dim h
With Exg2antt1
With .Chart
.FirstVisibleDate = #1/1/2001#
.HistogramVisible = True
.HistogramHeight = 32
.HistogramView = exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramLeafItems Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramUnlockedItems Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramCheckedItems
.Bars.Item("Task").HistogramPattern = exontrol.EXG2ANTTLib.PatternEnum.exPatternBDiagonal
End With
.Columns.Add("Column")
With .Items
h = .AddItem("Project")
.set_CellHasCheckBox(h,0,True)
.AddBar(.InsertItem(h,Nothing,"Item 1"),"Task",#1/2/2001#,#1/4/2001#)
.AddBar(.InsertItem(h,Nothing,"Item 2"),"Task",#1/3/2001#,#1/7/2001#)
.set_ExpandItem(h,True)
End With
End With
|
915
|
How can I show the histogram for all items

With Exg2antt1
.BeginUpdate()
.SingleSel = False
With .Chart
.FirstVisibleDate = #1/1/2001#
.LevelCount = 2
.HistogramVisible = True
.HistogramHeight = 32
.HistogramView = exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramAllItems
.Bars.Item("Task").HistogramPattern = exontrol.EXG2ANTTLib.PatternEnum.exPatternBDiagonal
End With
.Columns.Add("Column")
With .Items
.AddBar(.AddItem("Item 1"),"Task",#1/2/2001#,#1/4/2001#)
.AddBar(.AddItem("Item 2"),"Task",#1/3/2001#,#1/7/2001#)
End With
.EndUpdate()
End With
|
914
|
How can I prevent selecting a new item when clicking the chart area so my selection is shown in the histogram

With Exg2antt1
.SingleSel = False
With .Chart
.SelectOnClick = False
.FirstVisibleDate = #1/1/2001#
.HistogramVisible = True
.HistogramHeight = 32
.HistogramView = exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramSelectedItems
.Bars.Item("Task").HistogramPattern = exontrol.EXG2ANTTLib.PatternEnum.exPatternBDiagonal
End With
.Columns.Add("Column")
With .Items
.AddBar(.AddItem("Item 1"),"Task",#1/2/2001#,#1/4/2001#)
.AddBar(.AddItem("Item 2"),"Task",#1/3/2001#,#1/7/2001#)
.set_SelectItem(.get_ItemByIndex(0),True)
End With
End With
|
913
|
How can I show bars in the histogram for selected items only

With Exg2antt1
.SingleSel = False
With .Chart
.FirstVisibleDate = #1/1/2001#
.HistogramVisible = True
.HistogramHeight = 32
.HistogramView = exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramSelectedItems
.Bars.Item("Task").HistogramPattern = exontrol.EXG2ANTTLib.PatternEnum.exPatternBDiagonal
End With
.Columns.Add("Column")
With .Items
.AddBar(.AddItem("Item 1"),"Task",#1/2/2001#,#1/4/2001#)
.AddBar(.AddItem("Item 2"),"Task",#1/3/2001#,#1/7/2001#)
.set_SelectItem(.get_ItemByIndex(0),True)
End With
End With
|
912
|
How can I change the color and size for the curve in the histogram

Dim h1
With Exg2antt1
.BeginUpdate()
.Columns.Add("Tasks")
With .Chart
.LevelCount = 2
.NonworkingDays = 0
.set_PaneWidth(False,64)
.FirstVisibleDate = #6/20/2005#
.HistogramVisible = True
.HistogramHeight = 68
With .Bars.Item("Task")
.HistogramPattern = &H100 Or exontrol.EXG2ANTTLib.PatternEnum.exPatternDot
.HistogramBorderColor = Color.FromArgb(0,255,0)
.HistogramBorderSize = 5
End With
End With
With .Items
h1 = .AddItem("Task")
.AddBar(h1,"Task",#6/21/2005#,#6/25/2005#,1,1)
.AddBar(h1,"Task",#6/23/2005#,#6/28/2005#,2,2)
End With
.EndUpdate()
End With
|
911
|
How can I change the color for the frame in the histogram

Dim h1
With Exg2antt1
.BeginUpdate()
.Columns.Add("Tasks")
With .Chart
.LevelCount = 2
.NonworkingDays = 0
.set_PaneWidth(False,64)
.FirstVisibleDate = #6/20/2005#
.HistogramVisible = True
.HistogramHeight = 68
With .Bars.Item("Task")
.HistogramPattern = &H100 Or exontrol.EXG2ANTTLib.PatternEnum.exPatternShadow
.HistogramItems = 5
.HistogramBorderColor = Color.FromArgb(255,0,0)
End With
End With
With .Items
h1 = .AddItem("Task")
.AddBar(h1,"Task",#6/21/2005#,#6/25/2005#,1,1)
.AddBar(h1,"Task",#6/23/2005#,#6/28/2005#,2,2)
End With
.EndUpdate()
End With
|
910
|
How can I force the histogram for a bar being shown all the time

Dim h1
With Exg2antt1
.BeginUpdate()
.ScrollBySingleLine = True
.Columns.Add("Tasks").set_Def(exontrol.EXG2ANTTLib.DefColumnEnum.exCellHasCheckBox,True)
With .Chart
.LevelCount = 2
.NonworkingDays = 0
.set_PaneWidth(False,64)
.FirstVisibleDate = #6/20/2005#
.HistogramVisible = True
.HistogramHeight = 68
.HistogramView = exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramUnlockedItems Or exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramCheckedItems
With .Bars.Copy("Task","H")
.Color = Color.FromArgb(0,255,0)
.HistogramPattern = &H100
.HistogramItems = 5
.HistogramColor = .Color
.HistogramGridLinesColor = Color.FromArgb(128,128,128)
.HistogramRulerLinesColor = Color.FromArgb(0,0,1)
End With
With .Bars.Item("Task")
.HistogramCriticalColor = Color.FromArgb(0,0,128)
.HistogramPattern = .Pattern
.HistogramItems = 5
.HistogramGridLinesColor = Color.FromArgb(128,128,128)
.HistogramRulerLinesColor = Color.FromArgb(0,0,1)
End With
End With
With .Items
h1 = .AddItem("Hidden")
.AddBar(h1,"H",#6/23/2005#,#6/28/2005#,1)
.AddBar(h1,"H",#6/24/2005#,#6/26/2005#,2)
.set_CellState(h1,0,1)
.set_ItemHeight(h1,0)
.set_SelectableItem(h1,False)
h1 = .AddItem("Task 1")
.AddBar(h1,"Task",#6/21/2005#,#6/25/2005#,1)
.set_CellState(h1,0,1)
h1 = .AddItem("Task 2")
.set_CellState(h1,0,1)
.AddBar(h1,"Task",#6/24/2005#,#7/1/2005#,1)
End With
.EndUpdate()
End With
|
909
|
How can I remove a bar type from the histogram

Dim h1
With Exg2antt1
.BeginUpdate()
.Columns.Add("Tasks")
With .Chart
.LevelCount = 2
.NonworkingDays = 0
.set_PaneWidth(False,40)
.FirstVisibleDate = #6/20/2005#
.HistogramVisible = True
.HistogramHeight = 32
With .Bars.Item("Task")
.HistogramCriticalColor = Color.FromArgb(0,0,128)
.HistogramPattern = .Pattern
End With
With .Bars.Copy("Task","Green")
.Color = Color.FromArgb(0,255,0)
.HistogramPattern = .Pattern
End With
End With
With .Items
h1 = .AddItem("Task 1")
.AddBar(h1,"Green",#6/22/2005#,#6/26/2005#,0)
.AddBar(h1,"Task",#6/21/2005#,#6/25/2005#,1)
.set_ItemBar(h1,1,exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarOffset,3)
h1 = .AddItem("Task 2")
.AddBar(h1,"Green",#6/28/2005#,#6/30/2005#,0)
.AddBar(h1,"Task",#6/27/2005#,#7/1/2005#,1)
.set_ItemBar(h1,1,exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarOffset,3)
End With
With .Chart.Bars.Item("Green")
.HistogramColor = .Color
.HistogramPattern = exontrol.EXG2ANTTLib.PatternEnum.exPatternEmpty
End With
.EndUpdate()
End With
|
908
|
How can I show the two buttons in the vertical splitter but still resizes the chart when the control gets resized

With Exg2antt1
.OnResizeControl = exontrol.EXG2ANTTLib.OnResizeControlEnum.exSplitterShowButtons Or exontrol.EXG2ANTTLib.OnResizeControlEnum.exResizeChart
.Chart.set_PaneWidth(False,96)
.Chart.LevelCount = 2
End With
|
907
|
I have seen a screen shot on your web page that shows two buttons on the vertical scroll bar. How can I show them
With Exg2antt1
.OnResizeControl = exontrol.EXG2ANTTLib.OnResizeControlEnum.exSplitterShowButtons
.Chart.set_PaneWidth(False,96)
End With
|
906
|
How can I disable selecting a new item once the user clicks the chart area

Dim h1
With Exg2antt1
.BeginUpdate()
.Columns.Add("Tasks")
.SingleSel = False
With .Chart
.SelectOnClick = False
.AllowCreateBar = exontrol.EXG2ANTTLib.CreateBarEnum.exCreateBarAuto
.LevelCount = 2
.set_PaneWidth(False,40)
.FirstVisibleDate = #6/20/2005#
.HistogramVisible = True
.HistogramHeight = 32
.HistogramView = exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramSelectedItems
.Bars.Item("Task").HistogramPattern = exontrol.EXG2ANTTLib.PatternEnum.exPatternSolid
End With
With .Items
h1 = .AddItem("Task 1")
.AddBar(h1,"Task",#6/22/2005#,#6/26/2005#,0)
.set_SelectItem(h1,True)
h1 = .AddItem("Task 2")
.AddBar(h1,"Task",#6/24/2005#,#6/30/2005#,0)
.set_SelectItem(h1,True)
End With
.EndUpdate()
End With
|
905
|
Is there any option to display the chart's header in the bottom side of the histogram

Dim h1
With Exg2antt1
.BeginUpdate()
.Columns.Add("Tasks")
With .Chart
.LevelCount = 2
.NonworkingDays = 0
.set_PaneWidth(False,40)
.FirstVisibleDate = #6/20/2005#
.HistogramVisible = True
.HistogramView = exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramAllItems
.HistogramHeight = 96
.HistogramHeaderVisible = True
With .Bars.Item("Task")
.Color = Color.FromArgb(0,0,255)
.OverlaidType = exontrol.EXG2ANTTLib.OverlaidBarsTypeEnum.exOverlaidBarsOffset
.OverlaidGroup = "Task2"
.HistogramCriticalColor = Color.FromArgb(0,0,128)
.HistogramPattern = exontrol.EXG2ANTTLib.PatternEnum.exBezierCurve
.HistogramType = exontrol.EXG2ANTTLib.HistogramTypeEnum.exHistOverAllocation
End With
With .Bars.Copy("Task","Task2")
.Color = Color.FromArgb(0,255,0)
.OverlaidType = exontrol.EXG2ANTTLib.OverlaidBarsTypeEnum.exOverlaidBarsOffset
.OverlaidGroup = "Task"
.HistogramCriticalColor = Color.FromArgb(0,128,0)
.HistogramPattern = exontrol.EXG2ANTTLib.PatternEnum.exBezierCurve
.HistogramType = exontrol.EXG2ANTTLib.HistogramTypeEnum.exHistOverAllocation
End With
End With
With .Items
h1 = .AddItem("Task 1")
.AddBar(h1,"Task2",#6/22/2005#,#6/26/2005#,0)
.AddBar(h1,"Task",#6/21/2005#,#6/25/2005#,1)
.set_ItemBar(h1,0,exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarEffort,3)
.set_ItemBar(h1,1,exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarEffort,4)
h1 = .AddItem("Task 2")
.AddBar(h1,"Task2",#6/28/2005#,#6/30/2005#,0)
.AddBar(h1,"Task",#6/27/2005#,#7/1/2005#,1)
.set_ItemBar(h1,0,exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarEffort,4)
.set_ItemBar(h1,1,exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarEffort,1)
End With
.EndUpdate()
End With
|
904
|
How can I display the child bars as soon as an item gets collapsed

Dim h,h1,h2,h3
With Exg2antt1
.BeginUpdate()
.LinesAtRoot = exontrol.EXG2ANTTLib.LinesAtRootEnum.exLinesAtRoot
.Columns.Add("Tasks")
With .Chart
.FirstVisibleDate = #9/20/2006#
.ShowCollapsedBars = True
.LevelCount = 2
.set_PaneWidth(False,96)
End With
With .Items
h = .AddItem("Project 1")
h1 = .InsertItem(h,Nothing,"Task 1")
.AddBar(h1,"Task",#9/21/2006#,#9/23/2006#,"A")
h2 = .InsertItem(h,Nothing,"Task 2")
.AddBar(h2,"Task",#9/24/2006#,#9/26/2006#,"B")
h3 = .InsertItem(h,Nothing,"Task 3")
.AddBar(h3,"Task",#9/27/2006#,#9/29/2006#,"C")
h = .AddItem("Project 2")
h1 = .InsertItem(h,Nothing,"Task 1")
.AddBar(h1,"Task",#9/21/2006#,#9/23/2006#,"A")
h2 = .InsertItem(h,Nothing,"Task 2")
.AddBar(h2,"Task",#9/24/2006#,#9/26/2006#,"B")
h3 = .InsertItem(h,Nothing,"Task 3")
.AddBar(h3,"Task",#9/27/2006#,#9/29/2006#,"C")
.set_ExpandItem(h,True)
End With
.EndUpdate()
End With
|
903
|
What exBarEffort property represents

Dim h1
With Exg2antt1
.BeginUpdate()
.Columns.Add("Tasks")
With .Chart
.LevelCount = 2
.set_PaneWidth(False,40)
.FirstVisibleDate = #6/9/2005#
.HistogramVisible = True
.HistogramView = exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramAllItems
.HistogramHeight = 164
With .Bars.Item("Task")
.HistogramPattern = &H100
.HistogramType = exontrol.EXG2ANTTLib.HistogramTypeEnum.exHistOverAllocation
End With
End With
With .Items
h1 = .AddItem("Task 1")
.AddBar(h1,"Task",#6/10/2005#,#6/11/2005#,Nothing,"1/1=<b>100%")
.set_ItemBar(h1,Nothing,exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarHAlignCaption,18)
h1 = .AddItem("Task 2")
.AddBar(h1,"Task",#6/12/2005#,#6/14/2005#,Nothing,"1/2=<b>50%")
.set_ItemBar(h1,Nothing,exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarHAlignCaption,18)
h1 = .AddItem("Task 3")
.AddBar(h1,"Task",#6/15/2005#,#6/18/2005#,Nothing,"1/3=<b>33%")
.set_ItemBar(h1,Nothing,exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarHAlignCaption,18)
h1 = .AddItem("Task 4")
.AddBar(h1,"Task",#6/19/2005#,#6/23/2005#,Nothing,"1/4=<b>25%")
.set_ItemBar(h1,Nothing,exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarHAlignCaption,18)
h1 = .AddItem("Task 5")
.AddBar(h1,"Task",#6/24/2005#,#6/29/2005#,Nothing,"1/5=<b>20%")
.set_ItemBar(h1,Nothing,exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarHAlignCaption,18)
End With
.EndUpdate()
End With
|
902
|
Can I display multiple curves in the histogram

Dim h1
With Exg2antt1
.BeginUpdate()
.Columns.Add("Tasks")
With .Chart
.LevelCount = 2
.NonworkingDays = 0
.set_PaneWidth(False,40)
.FirstVisibleDate = #6/20/2005#
.HistogramVisible = True
.HistogramView = exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramAllItems
.HistogramHeight = 64
With .Bars.Item("Task")
.Color = Color.FromArgb(0,0,255)
.OverlaidType = exontrol.EXG2ANTTLib.OverlaidBarsTypeEnum.exOverlaidBarsOffset
.OverlaidGroup = "Task2"
.HistogramCriticalColor = Color.FromArgb(0,0,128)
.HistogramPattern = exontrol.EXG2ANTTLib.PatternEnum.exBezierCurve
.HistogramType = exontrol.EXG2ANTTLib.HistogramTypeEnum.exHistOverAllocation
End With
With .Bars.Copy("Task","Task2")
.Color = Color.FromArgb(0,255,0)
.OverlaidType = exontrol.EXG2ANTTLib.OverlaidBarsTypeEnum.exOverlaidBarsOffset
.OverlaidGroup = "Task"
.HistogramCriticalColor = Color.FromArgb(0,128,0)
.HistogramPattern = exontrol.EXG2ANTTLib.PatternEnum.exBezierCurve
.HistogramType = exontrol.EXG2ANTTLib.HistogramTypeEnum.exHistOverAllocation
End With
End With
With .Items
h1 = .AddItem("Task 1")
.AddBar(h1,"Task2",#6/22/2005#,#6/26/2005#,0)
.AddBar(h1,"Task",#6/21/2005#,#6/25/2005#,1)
.set_ItemBar(h1,0,exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarEffort,3)
.set_ItemBar(h1,1,exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarEffort,4)
h1 = .AddItem("Task 2")
.AddBar(h1,"Task2",#6/28/2005#,#6/30/2005#,0)
.AddBar(h1,"Task",#6/27/2005#,#7/1/2005#,1)
.set_ItemBar(h1,0,exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarEffort,4)
.set_ItemBar(h1,1,exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarEffort,1)
End With
.EndUpdate()
End With
|
901
|
How can I use the exBarEffort property

Dim h1
With Exg2antt1
.BeginUpdate()
.Columns.Add("Tasks")
With .Chart
.LevelCount = 2
.NonworkingDays = 0
.set_PaneWidth(False,40)
.FirstVisibleDate = #6/20/2005#
.HistogramVisible = True
.HistogramHeight = 64
.HistogramView = exontrol.EXG2ANTTLib.HistogramViewEnum.exHistogramAllItems
With .Bars.Item("Task")
.HistogramCriticalColor = Color.FromArgb(255,0,0)
.HistogramPattern = exontrol.EXG2ANTTLib.PatternEnum.exBezierCurve
.HistogramType = exontrol.EXG2ANTTLib.HistogramTypeEnum.exHistOverAllocation
End With
End With
With .Items
h1 = .AddItem("Task 1")
.AddBar(h1,"Task",#6/21/2005#,#6/25/2005#)
.set_ItemBar(h1,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarEffort,4)
h1 = .AddItem("Task 2")
.AddBar(h1,"Task",#6/27/2005#,#7/1/2005#)
.set_ItemBar(h1,"",exontrol.EXG2ANTTLib.ItemBarPropertyEnum.exBarEffort,1)
End With
.EndUpdate()
End With
|